Forum Discussion

PowerBIBeginer's avatar
4 years ago
Solved

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's avatar
    v-zhangti
    Icon for Community Support rankCommunity 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.