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.
Hello, I have the measure below and it works fine:
Televisions Price per Unit = CALCULATE([Revenue]; DB[Product] = "Television") / CALCULATE([Amount]; DB[Product] = "Television")
I wonder if it is possible, just for the sake of my perfeccionism, to filter first the DB table only the rows containing Television and then sum each columns' values and do the division operation. The fact that I must explicitly express the filter context DB[Product] = "Television" bothers me and there may be a better and elegant way.
Also: without breaking the storage engine security.
Thanks!
Solved! Go to Solution.
So something like:
Televisions Price per Unit = VAR __tmpTable = FILTER('DB',[Product]="Television") RETURN DIVIDE( SUMX(__tmpTable,[Revenue]), SUMX(__tmpTable,[Amount]), 0 )
So something like:
Televisions Price per Unit = VAR __tmpTable = FILTER('DB',[Product]="Television") RETURN DIVIDE( SUMX(__tmpTable,[Revenue]), SUMX(__tmpTable,[Amount]), 0 )
Thanks, I wonder if it is less efficient than using CALCULATE. I will test it later in DAX Studio.
Have a good day.
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 |
---|---|
113 | |
99 | |
80 | |
70 | |
59 |
User | Count |
---|---|
149 | |
114 | |
107 | |
89 | |
67 |