Forum Discussion
Distinct Count by Year
Hello, I believe I just need a relatively easy fix, but I'm struggling to get there. Hoping somebody can help. I am able to find the distinct number of months of a given plan year (not calen...
Anonymous I think you are trying to show the # months in your year even when you are just looking at one month? If so, this may work for you!
Count Months in Year = if(ISINSCOPE('calendar'[Month]),
CALCULATE(DISTINCTCOUNT('calendar'[Month]),'calendar'[Month]),
DISTINCTCOUNT('calendar'[Month]))