Forum Discussion
Row based slicer
Hey guys, I have a small problem and I'm not sure weather its possible to do it in PowerBI or not (it's easy in Excel though). So there are 3 rows "EBIT, OPEX and Order Entry" that can be sli...
A friendy coleague just helped me out, we used following measure to achieve what I was looking for, since your solution didn't work out:
SumValue = IF(HASONEVALUE('Table'[KPI]); SWITCH(VALUES('Table'[KPI]); "EBIT";CALCULATE(SUM('Table'[VALUE]);ALL('Table'[EX_DT_IN]));SUM('Table'[VALUE]) ))
Use a CALCULATE with an ALL filter.