Forum Discussion

PBIfanatic's avatar
PBIfanatic
Helper V
4 years ago
Solved

Selected Value issue

Hi,   I am trying to represent the below data   Category Product Sales Cat1 Prod1 100 Cat1 Prod2 200 Cat2 Prod3   Cat2 Prod4     as this, with a conditional format b...
Need Help
  • v-yalanwu-msft's avatar
    v-yalanwu-msft
    4 years ago

    Hi， PBIfanatic ；

    You could create a table as a slicer by cate column,then modify the measure as follow:

    1.create a table as slicer.

    slicer = VALUES('Table'[Category])

    2.then modify measure.

    Measure = IF(ISFILTERED(slicer[Category]), CALCULATE(SUM([Sales]),FILTER(ALL('Table'),[Category]=SELECTEDVALUE('slicer'[Category]))),SUM([Sales]))

    The final output is shown below:

     

    Best Regards,
    Community Support Team_ Yalan Wu
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

v-yalanwu-msft's avatar
v-yalanwu-msft
Community Support
4 years ago

Hi， PBIfanatic ；

You could create a table as a slicer by cate column,then modify the measure as follow:

1.create a table as slicer.

slicer = VALUES('Table'[Category])

2.then modify measure.

Measure = IF(ISFILTERED(slicer[Category]), CALCULATE(SUM([Sales]),FILTER(ALL('Table'),[Category]=SELECTEDVALUE('slicer'[Category]))),SUM([Sales]))

The final output is shown below:

 

Best Regards,
Community Support Team_ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.