Forum Discussion

NavyaMounika's avatar
NavyaMounika
Icon for Helper I rankHelper I
1 year ago
Solved

Need Intersection results when select multiple option from Slicer

Hi All,

 

I have a dataset which contains multiple columns in which i have to focus only on 3 column basically which have been listed here Account, Task Name and Baseline. Below is the sample data. In baseline column there are few entries of custom and blank entries too which is not added due to less space in message. I have to show task name in slicer that slicer also should filter based on only vanilla entries.  

 

I have to show only distinct account names in donut chart or any other graph where in common account name existing in all selected task names from the slicer.

 

For Example:

If I filter on " Backup Client Software Upgrade" this task name, accounts ACC3,ACC4,ACC5,ACC7 should display

If I filter on  "Backup Job Failure Report" this task name, accounts  ACC2,ACC3,ACC5,ACC6,ACC7 should display

If I filter on both " Backup Client Software Upgrade & Backup Job Failure Report" these task names, then ACC3,ACC5,ACC7 should display in result

If I filter on " Backup Client Software Upgrade, Daily replication check for backup data & Backup Job Failure Report" these task names, then ACC3,ACC5,ACC7

If I filter on " Backup Client Software Upgrade& Daily replication check for backup data" these task names, then ACC3,ACC4,ACC5,ACC7 should display in resultant graph.

 

Account Task Name Baseline
ACC7 Daily replication check for backup data VANILLA
ACC7 Backup Job Failure Report VANILLA
ACC7 Backup Job Success Report VANILLA
ACC7 Backup Media Cleanup VANILLA
ACC4 Daily Backup Status Report VANILLA
ACC4 Daily Backup Status Report VANILLA
ACC4 Daily Backup Status Report VANILLA
ACC4 Daily Backup Status Report VANILLA
ACC4 Daily Backup Status Report VANILLA
ACC4 Monthly Backup Status Report VANILLA
ACC4 Monthly Backup Status Report VANILLA
ACC4 Monthly Backup Status Report VANILLA
ACC4 Monthly Backup Status Report VANILLA
ACC4 Daily Backup Status Report VANILLA
ACC3 Backup Job Success Report VANILLA
ACC3 Backup Media Cleanup VANILLA
ACC3 Daily Backup Status Report VANILLA
ACC3 Daily Backup Status Report VANILLA
ACC3 Daily Backup Status Report VANILLA
ACC3 Daily replication check for backup data VANILLA
ACC3 Daily Backup Status Report VANILLA
ACC2 Backup Job Success Report VANILLA
ACC2 Backup License Utilization Report VANILLA
ACC1 Daily Backup Status Report VANILLA
ACC1 DR_sync report for Isilon cluster VANILLA
ACC1 Daily Backup Status Report VANILLA
ACC1 Backup Drive Threshold Report VANILLA
ACC5 Backup Media Cleanup VANILLA
ACC5 Daily replication check for backup data VANILLA
ACC5 Backup Job Success Report VANILLA
ACC2 Daily replication check for backup data VANILLA
ACC7 Transfer and Install the Backup SW agent VANILLA
ACC7 Backup License Utilization Report VANILLA
ACC7 Backup Client Software Upgrade VANILLA
ACC7 Backup Library Space utilization VANILLA
ACC3 Backup License Utilization Report VANILLA
ACC3 Backup Job Failure Report VANILLA
ACC3 Backup Client Software Upgrade VANILLA
ACC3 Commserv Anomaly Alert VANILLA
ACC3 Transfer and Install the Backup SW agent VANILLA
ACC3 Backup Library Space utilization VANILLA
ACC2 Backup Job Failure Report VANILLA
ACC2 Backup Library Space utilization VANILLA
ACC5 Backup Job Failure Report VANILLA
ACC5 Backup License Utilization Report VANILLA
ACC5 Commserv Anomaly Alert VANILLA
ACC2 Transfer and Install the Backup SW agent VANILLA
ACC5 Transfer and Install the Backup SW agent VANILLA
ACC5 Backup Client Software Upgrade VANILLA
ACC5 Backup Library Space utilization VANILLA
ACC6 Data Domain Utilization report VANILLA
ACC6 Backup Job Failure Report VANILLA
ACC6 Backup Replication Report VANILLA
ACC6 Successfully Backup Jobs Report VANILLA
ACC6 No Backup Report VANILLA
ACC6 Device went offline VANILLA
ACC4 Transfer and Install the Backup SW agent VANILLA
ACC4 Daily replication check for backup data VANILLA
ACC1 Daily replication check for backup data VANILLA
ACC4 Backup Client Software Upgrade VANILLA

 

Please help me with the resolution on this scenario. Looking forward for your help to resolve this problem.

 

Thanks,

Navya

Need Help
  • Anonymous's avatar
    Anonymous
    1 year ago

    Hi NavyaMounika ,

    Do you want only Task Name with baseline "Vanilla" to exist in the slicer? Then you only need to modify the DAX of creating the Slicer table to this:

    Slicer = 
CALCULATETABLE(
    VALUES('Table'[Task Name]),
    FILTER('Table', 'Table'[Baseline] = "Vanilla")
)


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

6 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    1 year ago

    Hi NavyaMounika ,

    First you need to use this DAX to create a new table for slicer:

    Slicer = VALUES('Table'[Task Name])

    Please note that the table Slicer cannot have any relationship with other tables:

    Then use these two DAXs to create measures:

    Counts = 
VAR _count =
    COUNTROWS ( FILTER ( 'Table', [Task Name] IN VALUES ( Slicer[Task Name] ) ) )
RETURN
    _count
    Flag = 
VAR _slicer =
    COUNTROWS ( Slicer )
VAR _table =
    SUMX (
        FILTER ( ALLSELECTED ( 'Table' ), [Account] IN VALUES ( 'Table'[Account] ) ),
        [Counts]
    )
RETURN
    IF (
        ISFILTERED ( Slicer[Task Name] ),
        IF (
            _slicer = 1
                && _table > 0,
            1,
            IF ( _slicer > 1 && _slicer = _table, 1, 0 )
        ),
        1
    )

    Then click on your donut chart or any other graph and drag the measure Flag into the Filters on this visual and set the measure Flag = 1:

    And the final output is as below:


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

    • NavyaMounika's avatar
      NavyaMounika
      Icon for Helper I rankHelper I
      1 year ago

      Hi,

      Firstly I really thank you for your response.

      The above logic is working however same i am implenting on below dataset, its not working 

       

      Account Task Name Baseline
      ACC7 Daily replication check for backup data VANILLA
      ACC7 Backup Job Failure Report VANILLA
      ACC3 Daily replication check for backup data VANILLA
      ACC5 Daily replication check for backup data VANILLA
      ACC2 Daily replication check for backup data VANILLA
      ACC7 Backup Client Software Upgrade VANILLA
      ACC3 Backup Job Failure Report VANILLA
      ACC3 Backup Client Software Upgrade VANILLA
      ACC2 Backup Job Failure Report VANILLA
      ACC5 Backup Job Failure Report VANILLA
      ACC5 Backup Client Software Upgrade VANILLA
      ACC6 Backup Job Failure Report VANILLA
      ACC4 Daily replication check for backup data VANILLA
      ACC1 Daily replication check for backup data VANILLA
      ACC4 Backup Client Software Upgrade VANILLA
      ACC4 Daily Backup Status Report CUSTOM
      ACC4 Daily Backup Status Report CUSTOM
      ACC4 Daily Backup Status Report CUSTOM
      ACC4 Daily Backup Status Report CUSTOM
      ACC4 Daily Backup Status Report CUSTOM
      ACC4 Daily Backup Status Report CUSTOM
      ACC3 Daily Backup Status Report CUSTOM
      ACC3 Daily Backup Status Report CUSTOM
      ACC3 Daily Backup Status Report CUSTOM
      ACC3 Daily Backup Status Report CUSTOM
      ACC1 Daily Backup Status Report CUSTOM
      ACC1 Daily Backup Status Report CUSTOM
      ACC1 Backup Drive Threshold Report CUSTOM
      ACC3 Commserv Anomaly Alert CUSTOM
      ACC5 Commserv Anomaly Alert CUSTOM
      ACC6 Data Domain Utilization report CUSTOM
      ACC4 Monthly Backup Status Report
      ACC4 Monthly Backup Status Report
      ACC4 Monthly Backup Status Report
      ACC4 Monthly Backup Status Report
      ACC2 Backup License Utilization Report
      ACC1 DR_sync report for Isilon cluster
      ACC7 Backup License Utilization Report
      ACC7 Backup Library Space utilization
      ACC3 Backup License Utilization Report
      ACC3 Backup Library Space utilization
      ACC2 Backup Library Space utilization
      ACC5 Backup License Utilization Report
      ACC5 Backup Library Space utilization
      ACC6 Device went offline

       

      Can you please look this dataset once.

       

      Thanks

      Navya

      • Anonymous's avatar
        Anonymous
        Not applicable
        1 year ago

        Hi NavyaMounika ,

        Can you clarify which side is not working?
        I changed the dataset:

        But it is still working, I did not modify any DAX at all, and all the steps are exactly the same as the one above.:


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