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 there,
I am looking to create a measure that counts the unique values of column "Batch" if the "Severity" column equals BLANK, Minor, or Event while also excluding the value from the count if the "Severity" column equals Major or Critical. For example based on the table below, the measure should equal 4 because it includes batches A, C, D, H, while excluding batches B and G.
I tried using the formula:
Solved! Go to Solution.
Hi @MikePowerBI
Try this measure:
Measure =
VAR _A =
CALCULATETABLE (
VALUES ( 'Table'[Batch] ),
FILTER ( 'Table', 'Table'[Severity] IN { "", "Minor", "Event" } )
)
VAR _B =
CALCULATETABLE (
VALUES ( 'Table'[Batch] ),
FILTER ( 'Table', 'Table'[Severity] IN { "Major", "Critical" } )
)
VAR _C =
EXCEPT ( _A, _B )
RETURN
COUNTROWS ( _C )
output:
If this post helps, please consider accepting it as the solution to help the other members find it more quickly.
Appreciate your Kudos!!
LinkedIn: www.linkedin.com/in/vahid-dm/
Hi @MikePowerBI
Try this measure:
Measure =
VAR _A =
CALCULATETABLE (
VALUES ( 'Table'[Batch] ),
FILTER ( 'Table', 'Table'[Severity] IN { "", "Minor", "Event" } )
)
VAR _B =
CALCULATETABLE (
VALUES ( 'Table'[Batch] ),
FILTER ( 'Table', 'Table'[Severity] IN { "Major", "Critical" } )
)
VAR _C =
EXCEPT ( _A, _B )
RETURN
COUNTROWS ( _C )
output:
If this post helps, please consider accepting it as the solution to help the other members find it more quickly.
Appreciate your Kudos!!
LinkedIn: www.linkedin.com/in/vahid-dm/
Hi VahidDM. This worked great, thank you for your prompt reply!
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 |
---|---|
96 | |
93 | |
82 | |
70 | |
64 |
User | Count |
---|---|
118 | |
106 | |
93 | |
79 | |
72 |