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.
Team,
How do I count only"Met" from the below DAX results?
=IF( CALCULATE(sum('Data_C3 Level'[Vol L15]), 'Data_C3 Level'[Plan/Act]= "2022 Act") - CALCULATE(sum('Data_C3 Level'[Vol L15]), 'Data_C3 Level'[Plan/Act]= "2022 Plan")<0,"Not Met","Met")
Solved! Go to Solution.
Hello @Kunder,
Can you please try:
Met Count =
COUNTROWS(
FILTER(
ALL('Data_C3 Level'),
IF(
CALCULATE(SUM('Data_C3 Level'[Vol L15]), 'Data_C3 Level'[Plan/Act] = "2022 Act") -
CALCULATE(SUM('Data_C3 Level'[Vol L15]), 'Data_C3 Level'[Plan/Act] = "2022 Plan") < 0,
"Not Met",
"Met"
) = "Met"
)
)
Hi @Kunder
If you are slicing by multiple columns then you need to iterate over SUMMARIZE instead of VALUES
=
SUMX (
VALUES ( 'Data_C3 Level'[The Slicing By Column] ),
INT (
CALCULATE (
SUM ( 'Data_C3 Level'[Vol L15] ),
'Data_C3 Level'[Plan/Act] = "2022 Act"
)
- CALCULATE (
SUM ( 'Data_C3 Level'[Vol L15] ),
'Data_C3 Level'[Plan/Act] = "2022 Plan"
) < 0
)
)
Hello @Kunder,
Can you please try:
Met Count =
COUNTROWS(
FILTER(
ALL('Data_C3 Level'),
IF(
CALCULATE(SUM('Data_C3 Level'[Vol L15]), 'Data_C3 Level'[Plan/Act] = "2022 Act") -
CALCULATE(SUM('Data_C3 Level'[Vol L15]), 'Data_C3 Level'[Plan/Act] = "2022 Plan") < 0,
"Not Met",
"Met"
) = "Met"
)
)
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 |
---|---|
46 | |
28 | |
22 | |
12 | |
8 |
User | Count |
---|---|
75 | |
52 | |
46 | |
15 | |
12 |