Forum Discussion

IF's avatar
IF
Post Prodigy
5 years ago
Solved

Measure calculation with # value

Hi I have a table which contains similar info: Slicer1Slicer2Slicer3Value # A 07.2020 12 # B 07.2020 14 C1 A 07.2020 21 C2 A 07.2020 23 D1 B 07.2020 32 D2 B 07.2...
Need Help
  • v-lili6-msft's avatar
    v-lili6-msft
    5 years ago

    hi  IF 

    What is the logic of your expected output?

    for case 1, when you select slicer3 as "08.2020" and Slicer2 as "B", not select Slicer1, you want to see value 44 (that means you just want to see "#" in slicer1 )

    but for case 2, If I use slicer2 it works, but it doesn't work when I use slicer1. what is your logic of this case?

     

    Regards,

    Lin

  • IF's avatar
    IF
    Post Prodigy
    5 years ago

    Hi,

    Thanks for sharing, but I don't know how to do it in this scenario.

    Best