IsFiltered not working

[Dharini]

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)

If single selection is made ie say test1, Test1 related data is presented in table and  i have a measure column in same table and wanted to display the output as  Measure1

And if multiple selection is made or All option is selected in slicer, i want measure column to output as Measure 2.

For this , i have used the measure column as below,

FinalRes = IF(ISFILTERED(TestTable(Test)), Measure1,Measure2)

which doesnot work and always returns the Measure2 value.

Kindly do needful.

[PattemManohar · Accepted solution]

@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])