Forum Discussion
get total count based on value selected in filter
Hi All,
How do I get total count based on the value selected in filter? Pls suggest Dax..
Hi, PowerBIBeginer
Sample data:
Measure:
Count = CALCULATE(COUNT('Table'[Type]))If there is more than one type column, you can try:
Count = CALCULATE(COUNT('Table'[Type]),ALLEXCEPT('Table','Table'[Type]))Is this the result you expect? If not, can you provide some sample data and the output you expect?
Best Regards,
Community Support Team _Charlotte
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
1 Reply
- v-zhangti
Community Support
Hi, PowerBIBeginer
Sample data:
Measure:
Count = CALCULATE(COUNT('Table'[Type]))If there is more than one type column, you can try:
Count = CALCULATE(COUNT('Table'[Type]),ALLEXCEPT('Table','Table'[Type]))Is this the result you expect? If not, can you provide some sample data and the output you expect?
Best Regards,
Community Support Team _Charlotte
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.