Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
I have a list of dates with the type of member that signed up.
total count =
CALCULATE(
COUNT('Sheet1'[Account Type]),
FILTER(
ALLSELECTED('Sheet1'),
'Sheet1'[Date] <= MAX('Sheet1'[Date])
)
)
I want to do a cumulative count on a bar graph.
but my dax isn;t working.
Date | Account Type |
1/01/2023 | Basic |
1/01/2023 | Basic |
1/01/2023 | Basic |
1/01/2023 | Standard |
1/02/2023 | Basic |
1/02/2023 | Basic |
1/02/2023 | Standard |
1/02/2023 | Standard |
1/02/2023 | Standard |
Solved! Go to Solution.
Hi,
I am not sure how your semantic model looks like, but please check the below picture and the attached pbix file if it suits yours requirement.
Total count cumulate: =
CALCULATE (
COUNTROWS ( Data ),
FILTER (
ALLSELECTED ( Data ),
Data[Account Type] = MAX ( Data[Account Type] )
&& Data[Date] <= MAX ( Data[Date] )
)
)
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, @shaun96
Has your problem been solved, if so, please consider Accept a correct reply as the solution or share your own solution to help others find it. If not, please provide more information and your desired output.
Best Regards
Hi,
I am not sure how your semantic model looks like, but please check the below picture and the attached pbix file if it suits yours requirement.
Total count cumulate: =
CALCULATE (
COUNTROWS ( Data ),
FILTER (
ALLSELECTED ( Data ),
Data[Account Type] = MAX ( Data[Account Type] )
&& Data[Date] <= MAX ( Data[Date] )
)
)
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.
User | Count |
---|---|
52 | |
33 | |
19 | |
16 | |
15 |
User | Count |
---|---|
94 | |
84 | |
37 | |
22 | |
20 |