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.
I'm having a hard time figuring out what is wrong with my calculation other than its hideousness...
MEASURE: Stop Time Per Unit:=[Total Stop Time]/[Total Machines]
Now I need to add up all the process groups that fall under/contribute to that stop time:
STPU Overall:=CALCULATE([Stop Time Per Unit],DimID[Cause Group]="",DimID[Cause Group]="Unknown",DimID[Cause Group]="Supply Chain", DimID[Cause Group]="Design",DimID[Cause Group]="Engineering",etc, etc, etc, for the other 11 cause groups.)
Is there a better more efficient way of doing this? I guess I should also mention that when I add it up like this... it is: = BLANK
Thanks DAX experts
Solved! Go to Solution.
Hi @groffia,
If you have to list the values explicitly, you can try it out like this:
STPU Overall:=
CALCULATE (
[Stop Time Per Unit],
DimID[Cause Group]
IN { BLANK (), "Unknown", "Supply Chain", "Design", "Engineering", "etc" }
)
If the measure can read the values from a column, you can try it like this:
a = CALCULATE ( [Stop Time Per Unit], DimID[Cause Group] IN VALUES ( 'table1'[column] ) )
Note: table1 could be created by formula or by hand.
Best Regards,
Dale
Hi @groffia,
If you have to list the values explicitly, you can try it out like this:
STPU Overall:=
CALCULATE (
[Stop Time Per Unit],
DimID[Cause Group]
IN { BLANK (), "Unknown", "Supply Chain", "Design", "Engineering", "etc" }
)
If the measure can read the values from a column, you can try it like this:
a = CALCULATE ( [Stop Time Per Unit], DimID[Cause Group] IN VALUES ( 'table1'[column] ) )
Note: table1 could be created by formula or by hand.
Best Regards,
Dale
Hi Dale @v-jiascu-msft, what if I want to use the values from that other table and do some calculation like below , its not working as I have written here ... please let me know if you need me to explain my scenario more?
a = CALCULATE ( [Stop Time Per Unit] * values('table1[column2]), DimID[Cause Group] IN VALUES ( 'table1'[column] ) )
never mind made it to work refering to this link https://community.powerbi.com/t5/Desktop/DAX-Using-variables-inside-iterators-such-as-SUMX/td-p/5210...
I knew there was a simpler way... your solution worked flawlessly. Thank you for your help!
-Steve
Yes, I realize it is a redundancy... but unfortunately necessary.
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 |
---|---|
108 | |
100 | |
78 | |
64 | |
58 |
User | Count |
---|---|
148 | |
111 | |
94 | |
84 | |
67 |