Data modeling and understanding the physical layer are comparable with being a good driver and a good car mechanic. It's unnecessary to excel in both areas. Still, it helps tremendously when driving an F1 car through uncharted terrain if there is some understanding of how an F1 car works if repair becomes necessary.,
I tend to create tables using M or a combination of point-and-click and M, because these tables are treated as base tables if the model is refreshed and for this reason these tables will benefit from all the compression magic, whereas tables created using DAX are not that well compressed.
A common search strategy has to combine multiple items with an AND instead of the default OR. This Power BI file contains two DAX measures solving a search operation with the fancy name: relational division
This post shows how a dynamic member called Other can be used for Data Visualizations in Power BI in addition to the common requirement of the visualization of the TOP N or BOTTOM N members. A solution is used that utilizes a combination of data modeling and DAX.