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.
Hi,
I have the following measure(Actual) which when sliced by fields from Empl dim consumes lot of memory and visual takes a lot of time to load.When no slicer is selected,visual crashes with error.How can i optimize it.
Actual=SUMX('Empl Dim',DIVIDE([USDCost],[HC],BLANK()))
USDCost = CALCULATE(sum(Budget[PerHead])*[HC])
@Anonymous - I have a series on DAX performance tuning:
https://community.powerbi.com/t5/Community-Blog/Performance-Tuning-DAX-Part-1/ba-p/976275
https://community.powerbi.com/t5/Community-Blog/Performance-Tuning-DAX-Part-2/ba-p/976813
Could maybe be DISTINCTCOUNT, perhaps try changing that to COUNTROWS just to test. Otherwise, could be your SUMX since it iterates over all rows in the table.
Otherwise, difficult to say without something to test with.
Usage table contains user,application combination and countrows will simply count all rows.I need unique count of usernames
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 |
---|---|
13 | |
2 | |
2 | |
1 | |
1 |