Forum Discussion

jtgriffin's avatar
jtgriffin
Frequent Visitor
6 years ago
Solved

Using a Measure as a visual filter

Hello,    I am working on building a dashboard that provides a way to filter and search through business opportunties that might be a benefit to your company.    HOwever, I am having an issue wit...
Need Help
Tips and Tricks
  • v-gizhi-msft's avatar
    v-gizhi-msft
    6 years ago

    Hi,

     

    According to your description, I create a table to test:

    Then, create a measure to calculate the rows of sales which sales are > 100:

    Measure = COUNTROWS(FILTER(ALLSELECTED(Sales),Sales[Sales]>100))

    Choose a pie chart visual, and then choose the count of [Increment] row as a card visual:

    For your problem why this measure cannot filter the card is that they have no same field, please add the same field to this pie chart visual, and when you click this pie chart, it will filter the card:

     

     

    Best Regards,

    Giotto Zhi

v-gizhi-msft's avatar
v-gizhi-msft
Community Support
6 years ago

Hi,

 

According to your description, I create a table to test:

Then, create a measure to calculate the rows of sales which sales are > 100:

Measure = COUNTROWS(FILTER(ALLSELECTED(Sales),Sales[Sales]>100))

Choose a pie chart visual, and then choose the count of [Increment] row as a card visual:

For your problem why this measure cannot filter the card is that they have no same field, please add the same field to this pie chart visual, and when you click this pie chart, it will filter the card:

 

 

Best Regards,

Giotto Zhi