Forum Discussion
Display Subtotal Column Based on Another Column's Values in Power BI
Hi everyone, Sorry for re-posting but I'm pretty desperate about this issue 😓 I hope you can help me with this issue. I appreciate it!!! Context: You can see from the attached image bel...
Hi Anonymous
I am probably misunderstanding but why not reference your existing measure in the total?
IF(not( ISINSCOPE(financial_percentage[Metric])), [USG_Global], CALCULATE (SELECTEDVALUE ( financial_percentage[Metric Value] ),FILTER ( ALL ( dim_region ), dim_region[region_name] = "Global" ))
)
Hello Anonymous
Try using thius measuire and see if it fulfils your requirement or not.
Metric Value with USG Subtotal =
SUMX(
VALUES(YourTable[company_name]),
CALCULATE(SUM(YourTable[Metric Value]), YourTable[USG])
)
I hope my solution helps! If it works for you and resolves the issue you're facing, please consider marking it as the solution. This will make it easier for others who encounter the same problem to find the answer and save them some time.
If you're happy with the solution, feel free to provide some Kudos