Forum Discussion

Kratos_ZA's avatar
Kratos_ZA
Icon for Helper I rankHelper I
5 years ago
Solved

Count based on dynamic filter

Hi Friends,   Please assist me with this issue I can't seem to solve:   So as you can see in the table, I have customer/franchisee names and below that are the stores they have. I created a...
Need Help
  • PaulDBrown's avatar
    PaulDBrown
    5 years ago

    Try:

    Count of Store =
CALCULATE (
    DISTINCTCOUNT ( 'Table'[Cutsomer name] ),
    FILTER ( Table, NOT ( ISBLANK ( [COLOR FILTER] ) ) )
)

     

PaulDBrown's avatar
PaulDBrown
Icon for Community Champion rankCommunity Champion
5 years ago

Try:

Count of Store =
CALCULATE (
    DISTINCTCOUNT ( 'Table'[Cutsomer name] ),
    FILTER ( Table, NOT ( ISBLANK ( [COLOR FILTER] ) ) )
)

 

  • Kratos_ZA's avatar
    Kratos_ZA
    Icon for Helper I rankHelper I
    5 years ago

    Thank you sir! Appreciate the help. This worked perfectly:)