Forum Discussion
COUNT
Hi Everyone, I'm having a hard time how to figure this out by counting the column Value by Region. As you can see below, total counts on each Value is the same. Your help is greatly appreciated. ...
Anonymous
You can try this calculated column:
Column =
CALCULATE(DISTINCTCOUNT('Table'[Value]),FILTER(ALLSELECTED('Table'),'Table'[Region]=EARLIER('Table'[Region])))
Is your data formed through Unpivot Columns? You don’t need this step or you can display the results you need.
Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.
Best Regards,
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly