Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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.
Solved! Go to 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....
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])
Proud to be a PBI Community Champion
@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....
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])
Proud to be a PBI Community Champion
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
65 |
User | Count |
---|---|
136 | |
118 | |
101 | |
71 | |
61 |