Card visual to filter table not working.

[ts2340]

So I'm very new to PBI.. ChatGPT has helped me so far create this table.. Basically what I want is to display the total count of "Intune Issues", which I have as a card using "Count" and selecting the "Intune Issues" field.

I then want two other cards that show the total count of each of the Intune Issues (Either "Not In Intune" or "Intune Issue"). I have those as well in both a card that is just using count with a filter and also a card using a measure.. 

I want to be able to select each of the cards to then filter the table's results.. As in, selecteing the "total count" card show all records, selecting "Not In Intune" just shows those records, etc. I can't figure out what I'm doing wrong..

Any help is appreciated. Thanks

[Anonymous · Accepted solution]

Hi @ts2340 ,

As Greg_Deckler said.Card visuals can't filter other visuals.

So you need to create a slicer that can dynamically filter the visual it is associated with.

countAll_ = COUNTROWS('Table')

countOfIntuneIssue = CALCULATE(COUNTROWS('Table'),'Table'[Intune issues] = "Intune issues")

countOfNotIntuneIssue = CALCULATE(COUNTROWS('Table'),'Table'[Intune issues] = "not in intune")

Refer to below document:

Slicers in Power BI - Power BI | Microsoft Learn

Best Regards,
Adamk Kong

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Greg_Deckler]

@ts2340 Card visuals can't filter other visuals.

[ts2340]

Thanks for the reply. Any suggestions on how to accomplish what I'm looking to do?