Forum Discussion

Vishwamber's avatar
Vishwamber
Frequent Visitor
3 years ago
Solved

Slicer for multi cell value

I have columns which is kind of  following cell value at different cells. r1,r2,r3 r1,r2 r1 r2 r2,r3,r4   i was trying to create slicer selection of unique value from above column likes of r1 ...
Need Help
  • Anonymous's avatar
    Anonymous
    3 years ago

    Hi Vishwamber 

    You can just modified the measure

    Measure = IF(COUNTROWS(FILTER(VALUES('Query1 (2)'[Value]),CONTAINSSTRING(SELECTEDVALUE(Query1[plat]),[Value])))>0,CALCULATE(COUNTA(Query1[TC])),0)

    Then create a new measure and put the measure to the table visual filter and put the new measure to the pie chart 

    Measure1 = SUMX(Query1,[Measure])

     

    Output

    Best Regards!

    Yolo Zhu

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

     

     

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Hi Vishwamber 

You can just modified the measure

Measure = IF(COUNTROWS(FILTER(VALUES('Query1 (2)'[Value]),CONTAINSSTRING(SELECTEDVALUE(Query1[plat]),[Value])))>0,CALCULATE(COUNTA(Query1[TC])),0)

Then create a new measure and put the measure to the table visual filter and put the new measure to the pie chart 

Measure1 = SUMX(Query1,[Measure])

 

Output

Best Regards!

Yolo Zhu

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

 

 

Vishwamber's avatar
Vishwamber
Frequent Visitor
3 years ago

Thanks a lot Yolo Zhu.