Forum Discussion

sarjensystems1's avatar
sarjensystems1
Helper III
6 years ago
Solved

IGNORE SLICER IN MEASURE.

Hii i need to calculate gross value..gross value=A(category)-selected category if i select B in the slicer then gross Value should be gross value= -10(26-36) if i select D in the slicer then...
Need Help
  • v-gizhi-msft's avatar
    v-gizhi-msft
    6 years ago

    Hi,

     

    Please try this measure:

    Measure = CALCULATE(SUM('Table'[Value]),FILTER(ALL('Table'),'Table'[category]="A"))-CALCULATE(SUM('Table'[Value]),FILTER(ALL('Table'),'Table'[category]=SELECTEDVALUE('Table'[category])))

    Choose this measure as a card visual and when you select category in slicer, it shows:

      

     

    Best Regards,

    Giotto Zhi

v-gizhi-msft's avatar
v-gizhi-msft
Community Support
6 years ago

Hi,

 

Please try this measure:

Measure = CALCULATE(SUM('Table'[Value]),FILTER(ALL('Table'),'Table'[category]="A"))-CALCULATE(SUM('Table'[Value]),FILTER(ALL('Table'),'Table'[category]=SELECTEDVALUE('Table'[category])))

Choose this measure as a card visual and when you select category in slicer, it shows:

  

 

Best Regards,

Giotto Zhi