Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
The Power BI DAX engine uses a semantic data model approach. The idea is you design, load and structure your data in (ideally) a star schema, use the visuals to structure the data On the page and measures to create the buisness logic. I can tell from your measure that you are not leveraging these things for your solution. There should be no need to use GENERATE, SUMMARIZE, ADDCOLUMNS, RELATEDTABLE in most DAX measures. those that write measures this way normally have a SQL background. You need to look at the problem differently in DAX.
This article I wrote may help you. https://exceleratorbi.com.au/the-optimal-shape-for-power-pivot-data/
Please let us know what exactly you wanted to get from that measure.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
112 | |
99 | |
82 | |
70 | |
63 |
User | Count |
---|---|
145 | |
111 | |
104 | |
84 | |
64 |