Card Visuals not Updating with slicers

[AMBP73]

Hello Everyone,

I have several cards in a report that show values calculated with measures, some as a count and others as a percentage. 

When using slicers with the same column values, the respective cards showin a count won't update, or with cards showing percentage the results are way off?

**This is only happening when using a slicer with the same column values, when using other slicers it works fine**

Could someone please give me insight to what the issue may be? Some google searching suggests tgat it may be because I have used a measure on the cards? But the descriptions do not indicate the exact problem I am having....

Thankyou in advance for any assisstance

[Anonymous · Accepted solution]

Hi @AMBP73 ,

I'm guessing that this field is filtered in your measure, for example:

Measure = CALCULATE(AVERAGE('Table'[Column1]),'Table'[Column1] >= 100000)

The code is actually patched in the engine:

Measure = CALCULATE(AVERAGE('Table'[Column1]),FILTER(ALL('Table'[Column1]),'Table'[Column1] >= 100000))

The code automatically ignores filtering from 'Table' [Column1].

So soultion is:

Measure = CALCULATE(AVERAGE('Table'[Column1]),FILTER(ALL('Table'[Column1]),'Table'[Column1] >= 100000),VALUES('Table'[Column1]))

Please check the pbix file.

Best Regards,
Gao
Community Support Team

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly --  How to provide sample data in the Power BI Forum

[LiamBluett]

Hi AMB, are your measures made using the same table that you're filtering? Perhaps it could be an issue with the relations in your data model. I find this is the most common cause of my filtering issues.

[AMBP73]

Hello Liam,

Thankyou for your response.

Yes, they are from the same table.

In fact, the specific issue relates to a slicer using a specific 'field'  (column) and a card visual using the same 'field (column) within a measure for that card. 

When filtering by another slicer the card visual modify accordingly.