cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Dharini Frequent Visitor
Frequent Visitor

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)

 

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.

 

1 ACCEPTED SOLUTION

Accepted Solutions
Super User
Super User

Re: IsFiltered not working

@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....

 

image.pngALL Selectedimage.pngSingle Selectionimage.pngMulti-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])


Did I answer your question? Mark my post as a solution !

Proud to be a Datanaut !





1 REPLY 1
Super User
Super User

Re: IsFiltered not working

@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....

 

image.pngALL Selectedimage.pngSingle Selectionimage.pngMulti-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])


Did I answer your question? Mark my post as a solution !

Proud to be a Datanaut !