Forum Discussion

sabinocivita's avatar
sabinocivita
Frequent Visitor
4 years ago
Solved

Use Distinctcount measure as filter

Hi all, I created a measure that is a distincount of a column (ie invoice number). Now I'd like to use distintcount as a filter in a dashboard. Example: in table object I have first column that is ...
  • v-easonf-msft's avatar
    v-easonf-msft
    4 years ago

    Hi, sabinocivita 

    You can consider creating a filter measure and then applying it to the table vissual filter pane to filter data.

    visual filter =
IF (
    ISFILTERED ( 'filter field'[count] ),
    IF (
        [distinctcount of invoices] <= SELECTEDVALUE ( 'filter field'[count] ),
        1,
        0
    ),
    1
)

    Best Regards,
    Community Support Team _ Eason

sabinocivita's avatar
sabinocivita
Frequent Visitor
4 years ago

Can you please tell me how to create the group table?

  • technolog's avatar
    technolog
    Icon for Super User rankSuper User
    4 years ago

    You can try create calc table like this:

    Calc table = SUMMARIZE ( 'Table', 'Table'[ClientID], "InvoiceCount", DISTINCTCOUNT('Table'[InvoiceID]) )