Get the repeating names monthly

[Radhika123]

Hi ,
I have training names column and date column. I need to know which training is repeating monthly.(for example if the power BI training is conducted in both march and april , then i need to get power BI as result ).please help me achieving this.
Thanks in Advance,

Radhika.

[ryan_mayu]

could you pls provide some sample data and expected output?

[Radhika123]

Thanks for the reply @ryan_mayu 
Sure, the data is like,
Training Name   Month    Attendee
Power BI             March    John         
Power BI             March    William    
power BI             April       Jack         
Power Apps        March     Jack
Power Apps        March       henry


Result will be like 
Month  Training Name  Result
March    Power BI            2
April       Power BI            2
March     Power Apps       1

As the power Bi repeated in both march and april , it should be 2 and the power apps is in only one month so it should be 1 

[ryan_mayu]

you can create a measure

Measure = CALCULATE(DISTINCTCOUNT('Table'[Month]),ALLEXCEPT('Table','Table'[Training Name]))

[Radhika123]

Thanks @ryan_mayu for the reply
but I apply the same , I'm getting all the months upto december but my data is upto may only and the measure is showing 12 for all  the trainings.Please check the snap shots below .please clarify why I am getting like this 

And the measure I have given is same like as you have given 

[ryan_mayu]

is the month column from the date table or fact table?

[Radhika123]

Hi @ryan_mayu 
it's from fact table only.

[ryan_mayu]

maybe you can try to distinctcount (month), not the date to see if this can show the correct output

[Radhika123]

Hi @ryan_mayu , Thanks
Got the answer but still showing the all months as it's filtering only two 
please check the snap shot