Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
Solved! Go to Solution.
Hi,
I tried to create a sample pbix file like below.
Please check the below picture and the attached pbix file.
DAX operators - DAX | Microsoft Learn
expected result measure: =
CALCULATE (
COUNTROWS ( VALUES ( 'STATUS'[ID] ) ),
'STATUS'[STATUS]
IN { "Waiting on customers", "Pending on user", "Pending Settlement" }
)
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.
Hi @Goudaaa ,
If you want to display the total count after each status, you can try the following measure.
MEASURE =
VAR _statu =
MAX ( 'Table'[STATUS] ) = "Waiting on customers"
|| MAX ( 'Table'[STATUS] ) = "Pending on user"
|| MAX ( 'Table'[STATUS] ) = "Pending Settlement"
VAR _count =
CALCULATE (
COUNT ( 'Table'[STATUS] ),
FILTER ( ALL ( 'Table' ), 'Table'[STATUS] = MAX ( 'Table'[STATUS] ) )
)
VAR _all =
CALCULATE (
COUNT ( 'Table'[STATUS] ),
FILTER (
ALL ( 'Table' ),
'Table'[STATUS] = "Waiting on customers"
|| 'Table'[STATUS] = "Pending on user"
|| 'Table'[STATUS] = "Pending Settlement"
)
)
RETURN
IF (
ISINSCOPE ( 'Table'[STATUS] ) && _statu,
_count,
IF ( NOT ISINSCOPE ( 'Table'[STATUS] ), _all )
)
If your Current Period does not refer to this, please clarify in a follow-up reply.
Best Regards,
Clara Gong
If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @Goudaaa ,
If you want to display the total count after each status, you can try the following measure.
MEASURE =
VAR _statu =
MAX ( 'Table'[STATUS] ) = "Waiting on customers"
|| MAX ( 'Table'[STATUS] ) = "Pending on user"
|| MAX ( 'Table'[STATUS] ) = "Pending Settlement"
VAR _count =
CALCULATE (
COUNT ( 'Table'[STATUS] ),
FILTER ( ALL ( 'Table' ), 'Table'[STATUS] = MAX ( 'Table'[STATUS] ) )
)
VAR _all =
CALCULATE (
COUNT ( 'Table'[STATUS] ),
FILTER (
ALL ( 'Table' ),
'Table'[STATUS] = "Waiting on customers"
|| 'Table'[STATUS] = "Pending on user"
|| 'Table'[STATUS] = "Pending Settlement"
)
)
RETURN
IF (
ISINSCOPE ( 'Table'[STATUS] ) && _statu,
_count,
IF ( NOT ISINSCOPE ( 'Table'[STATUS] ), _all )
)
If your Current Period does not refer to this, please clarify in a follow-up reply.
Best Regards,
Clara Gong
If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi,
I tried to create a sample pbix file like below.
Please check the below picture and the attached pbix file.
DAX operators - DAX | Microsoft Learn
expected result measure: =
CALCULATE (
COUNTROWS ( VALUES ( 'STATUS'[ID] ) ),
'STATUS'[STATUS]
IN { "Waiting on customers", "Pending on user", "Pending Settlement" }
)
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.
Check out the September 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
25 | |
18 | |
18 | |
17 | |
16 |
User | Count |
---|---|
28 | |
27 | |
19 | |
15 | |
14 |