Forum Discussion

ts2340's avatar
ts2340
New Member
2 years ago
Solved

Card visual to filter table not working.

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

Need Help
  • Anonymous's avatar
    Anonymous
    2 years ago

    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.

     

3 Replies

    • ts2340's avatar
      ts2340
      New Member
      2 years ago

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

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    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.