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

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