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

deevaker's avatar
deevaker
Resolver I
6 years ago

Hi,

 

I think what you can try is, create a calculated column where you put a condition where deal>100m then 1 else 0.

Now if you pull this column, then i think this should work.

 

Thanks,