card visualization cross filtering with data table

[sakshigrover]

I am working on a report in which I need to create a Card visualization showing number of Active Events.

I also have a Table that has details of Events. I need the ability to cross filter on Table on clicking on Card.

Basically, on click of Card I need to see all the events with ReviewStatus as Active.

Any clues?

[v-piga-msft]

Hi @sakshigrover,

It seems that you want to calculate the count of active Event.

Please refer to the fomula below.

Measure = CALCULATE(COUNT(Table1[status]),FILTER('Table1','Table1'[status]="Active"))

If you still need help, please share some data sample and your desired output.

Best Regards,

Cherry

[sakshigrover]

My Requirement is like this:

I need to show number of Active Events in the report. I am already able to do that  using a measure.

I also have a table in my report which shows the event details ( like Event ID, Event name etc.).

What I need is on click of Active event card, the Event Details table gets filtered.

I underrstand that card doesn't have filtering. Am I right?

If above is correct, then visually how should I show Active events count and on click of that event details table is also filtered.

[v-piga-msft]

Hi @sakshigrover,

I'm afraid that you are right.

For your scenario, you could try to use Bookmark to achieve that.

Best Regards,

Cherry