Forum Discussion

sakshigrover's avatar
sakshigrover
Frequent Visitor
8 years ago

card visualization cross filtering with data table

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 o...
Need Help
v-piga-msft's avatar
v-piga-msft
Resident Rockstar
8 years ago

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's avatar
sakshigrover
Frequent Visitor
8 years ago

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's avatar
    v-piga-msft
    Resident Rockstar
    8 years ago

    Hi sakshigrover,

     

    I'm afraid that you are right.

     

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

     

    Best Regards,

    Cherry