Forum Discussion

Dharini's avatar
Dharini
Frequent Visitor
7 years ago
Solved

IsFiltered not working

Hi All,   I have a Test slicer which drop downs test1,test2, test3.   Based on the slicer selection, Table visual is changed accordingly( have relation with the slicer data and visual table)   ...
Need Help
  • PattemManohar's avatar
    PattemManohar
    7 years ago

    Dharini It always appreciated if you can post some sample data in copiable format and expected output, to test and replicate the scenario for the solution you are looking for. 

     

    Anyway, I guess you are looking for something like this....

     

    ALL SelectedSingle SelectionMulti-Selection

    Here is the measure logic, I've used to display the Total Dept sal if there is single selection and Total salary of all departments if there is mult-selection.

     

    Test133Total = IF(COUNTROWS(VALUES(_Emp[Deptno]))>1,SUMX(ALL(_Emp),_Emp[Sal]),_KeyMeasures[Test133DeptTotal])
    Test133DeptTotal = SUM(_Emp[Sal])
PattemManohar's avatar
PattemManohar
Community Champion
7 years ago

Dharini It always appreciated if you can post some sample data in copiable format and expected output, to test and replicate the scenario for the solution you are looking for. 

 

Anyway, I guess you are looking for something like this....

 

ALL SelectedSingle SelectionMulti-Selection

Here is the measure logic, I've used to display the Total Dept sal if there is single selection and Total salary of all departments if there is mult-selection.

 

Test133Total = IF(COUNTROWS(VALUES(_Emp[Deptno]))>1,SUMX(ALL(_Emp),_Emp[Sal]),_KeyMeasures[Test133DeptTotal])
Test133DeptTotal = SUM(_Emp[Sal])