Percentage over Monthly Total

[Anonymous]

Hi

I need to calculate the percentage over month for the distinct cound of Customer IDs.

I'm using the following formula, but I am getting the percentage for the whole periods, and not by month

What am I doing wrong?

Thanks!

PercentageByMonth= 
DISTINCTCOUNT('FactTable'[ID]) /
CALCULATE(
   DISTINCTCOUNT('FactTable'[ID]);
   ALL('Calendar'[Year-Month])
)

[Anonymous · Accepted solution]

I've finally solved. I need to use the Field that is going to be used as a legends, not the fields from the calendar.

PercentageByMonth= 
DISTINCTCOUNT('FactTable'[ID]) /
CALCULATE(
   DISTINCTCOUNT('FactTable'[ID]);
   ALL('Table'[FieldUsedAsLegend])
)

[amitchandak]

Can you share sample data and sample output.