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 need to distinctcount the IDs when the status is only equal to "Pushed" or "Already pushed" (if an ID has a different status, don't count it). Here is a sample table :
ID | Status |
1 | Pushed |
2 | Pushed |
2 | To do |
The result should be 1 because only one ID has the status exactly equal to "Pushed" or "Already pushed". But my current measure is wrong because it returns 2. My current measure is :
How can I get this measure to return 1 ?
Thank you
Best regards
Solved! Go to Solution.
Here is one measure expression that should work.
Only Pushed =
COUNTROWS(
FILTER(
VALUES( T3[ID] ),
ISBLANK(
CALCULATE( COUNT( T3[ID] ), NOT T3[Status] IN { "Pushed", "Already Pushed" } )
)
)
)
Pat
To learn more about Power BI, follow me on Twitter or subscribe on YouTube.
Hi,
Please try the below measure, and check the attached file.
expected result: =
VAR allid =
VALUES ( 'Fact Assets'[ID] )
VAR idnotwant =
CALCULATETABLE (
VALUES ( 'Fact Assets'[ID] ),
NOT ( 'Fact Assets'[Status] IN { "Pushed", "Already pushed" } )
)
VAR onlyidwant =
EXCEPT ( allid, idnotwant )
RETURN
COUNTROWS ( onlyidwant )
If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.
Here is one measure expression that should work.
Only Pushed =
COUNTROWS(
FILTER(
VALUES( T3[ID] ),
ISBLANK(
CALCULATE( COUNT( T3[ID] ), NOT T3[Status] IN { "Pushed", "Already Pushed" } )
)
)
)
Pat
To learn more about Power BI, follow me on Twitter or subscribe on YouTube.
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 |
---|---|
106 | |
93 | |
75 | |
62 | |
50 |
User | Count |
---|---|
146 | |
109 | |
106 | |
88 | |
61 |