Explore and share Fabric Notebooks to boost Power BI insights in the new community notebooks gallery.
Check it out now!Microsoft is giving away 50,000 FREE Microsoft Certification exam vouchers. Get Fabric certified for FREE! Learn more
Hi All,
I understand calculating the TOTAL in PowerBi is always a challenge. But being new to DAX doesn't help.
I have read so many posts but I am not getting anywhere. I think it's something with SUMX but I have tried many different versions, and it still didn't work. =(
So will really need some help with this please:
Here is what I have in a database (simplifed version):
Desired outcome when put into a matrix/ table:
Desired outcome when I use my slicer to filter by sites on the matrix/ table:
What kind of DAX do I write please?
Thank you so much in advance!~
Hi @byWing ,
Power BI will automatically merge the categories. To display them this way, you need to add an [index] column in the PowerQuery Editor.]
Then drag these fields into the table.
Finally, adjust the font color of the [index] column to match the background color.
If Total is not correct, try this measure.
Measure =
SUMX(
SUMMARIZE(
'Table',
'Table'[Site],
"bugt",[@Budget]
),
[bugt]
)
Best Regards,
Gao
Community Support Team
If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!
How to get your questions answered quickly -- How to provide sample data in the Power BI Forum