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.
Hey Gurus,
I'm looking for help creating a measure that can calculate a percentage.
I have tried multiple way's of getting this to work and I'm also willing to split them into different measures if that is the only way to do it.
TotalLSC =
CALCULATE (
DIVIDE (
COUNTROWS ( FILTER ( 'data cfb', 'data cfb'[COM_DeliveryPMA] = 1
&& LEFT('data cfb'[Node Code], 3) = "LSC" )),
COUNTROWS ( FILTER ( 'data cfb', 'data cfb'[COM_DeliveryPMA] = 1 )
)))
I want to divide total rows where DeliveryPMA = 1 and Node Code starts with LSC divided by the total rows where DeliveryPMA = 1.
Thanks in advance, I really appreciate your help!
/B
Solved! Go to Solution.
hi @JesperBT
the issue might come from some unmentioned context, try like:
hi @JesperBT
the issue might come from some unmentioned context, try like:
Hi FreemanZ,
I don't know what the reason was, but it seems to work now.
Thanks a lot for taking the time to help me!
Best regards,
B
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 |
---|---|
42 | |
21 | |
21 | |
14 | |
14 |
User | Count |
---|---|
42 | |
39 | |
33 | |
19 | |
18 |