Forum Discussion
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...
PBIfanatic , I think you need an independent category table and use it as per need
refer if needed
Need of an Independent Table in Power BI: https://youtu.be/lOEW-YUrAbE
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.
PBIfanatic , I think you need an independent category table and use it as per need
refer if needed
Need of an Independent Table in Power BI: https://youtu.be/lOEW-YUrAbE
