Using a Measure as a visual filter

[jtgriffin]

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 with a visual filter. I created a measure to calculate how many of the deals are greater than 100million in proft. I then took that measure and placed it within a piechart and edited it to make it look like a card basically, since you cant filter off cards. In the example below I have filtered down the table to 68 opportunities (thats in the top right hand corner). I would then like to be able to click on the bottom piechart and have it filter my table to JUST those 10 opportunties. However, when I click the filter nothing happens. The table stays at a total of 68 instead of filtering down to 10. How can I fix this, thank everyone in advance for their help. 

[v-gizhi-msft · Accepted solution]

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]

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,