Need help in All, Allselected, AllExcept function

[Balaraju]

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.

[Jihwan_Kim · Accepted 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] )
)

[MahyarTF]

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.