Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Distinct Count Based on Multiple Dynamic Column Filters

I want to create a measure that counts distinct visit days (metric date) per customer that changes based on brand, channel and date filters. This is an example of the table that I have:   Wit...
  • Mariusz's avatar
    Mariusz
    6 years ago

    Hi Anonymous 

     

    Try this Measure.

    Measure = 
COUNTROWS(
    SUMMARIZE( 'Table', 'Table'[Customer ID], 'Table'[metric date] )
)

     

    Best Regards,
    Mariusz

    If this post helps, then please consider Accepting it as the solution.

    Please feel free to connect with me.
    LinkedIn


     

amitchandak's avatar
amitchandak
Super User
6 years ago

Anonymous , Try like can help

sumx(summarize(Table,Table[Customer ID],Table[Channel],"_1",distinctcount(Table[Date])),[_1])