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,
What is the correct measure to count [WO Measurement Status]="Missed" and "Missed Goal"?
I used the following measure and i want to count also "Missed Goal" status.
WO Missed = CALCULATE(COUNTROWS('WO'),'WO'[WO Measurement Status]="Missed")
Thanks
Solved! Go to Solution.
You can use IN operator
WO Missed and Missed Goal = CALCULATE ( COUNTROWS ( 'WO' ), 'WO'[WO Measurement Status] IN { "Missed", "Missed Goal" } )
You can use IN operator
WO Missed and Missed Goal = CALCULATE ( COUNTROWS ( 'WO' ), 'WO'[WO Measurement Status] IN { "Missed", "Missed Goal" } )
Thanks for your help. It's work.
Regards,
Zaky
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 |
---|---|
115 | |
100 | |
88 | |
69 | |
61 |
User | Count |
---|---|
152 | |
120 | |
102 | |
87 | |
68 |