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 but it doesn't work. If I use slicer2 it works, but it doesn't work when I use slicer1. It always shows 86 if nothing is selected in slicer2.

v-lili6-msft's avatar
v-lili6-msft
Community Support
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,

    It is solved with support of Ikalawski. 

     

    All the best