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.
HI All,
I have data for distinct count of customer based on monthly level, my requirement is in bar chart I want to show the distinct count of cutomer by monthly level and quarter level.
So which dax I want to use for quarter level.
The expected output is in below screenshot:
Sample Data:
Year Month Number | Distinct count of customer by month level |
2022-04 | 513 |
2022-05 | 549 |
2022-06 | 319 |
2022-07 | 481 |
2022-08 | 451 |
2022-09 | 351 |
2022-10 | 543 |
2022-11 | 508 |
2022-12 | 355 |
Thanks,
Balaraju.
Solved! Go to Solution.
Hi,
I am not sure how your datamodel looks like, but I tried to create a sample pbix file like below.
Please check the below picture and the attached pbix file.
quarterly customer count distinct: =
CALCULATE (
MAX(Data[Customer count]),
ALL ( Data[Month end], Data[Year Month Number] ),
VALUES ( Data[End of Quarter] )
)
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,
I am not sure how your datamodel looks like, but I tried to create a sample pbix file like below.
Please check the below picture and the attached pbix file.
quarterly customer count distinct: =
CALCULATE (
MAX(Data[Customer count]),
ALL ( Data[Month end], Data[Year Month Number] ),
VALUES ( Data[End of Quarter] )
)
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,
You need to define the type of the 'Year Month Number' column as a date and Format as a 'yyyy-mm', then develop the Line and Clustered Column chart and put the 'Year Month Number' in X-axis and 'Distinct of Month' in Y-axis and 'Distinct of Quarter' in Line Y-axis.
an also adjust the legend place and change the color for bar and line chart :
Thanks for Kudos and please mark it as a solution if it helps you.
User | Count |
---|---|
94 | |
79 | |
74 | |
63 | |
60 |
User | Count |
---|---|
108 | |
100 | |
77 | |
63 | |
61 |