The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
I have a table for accounting.
I would like to have a Matrix that only sums one of ny two values
In the matrix I have two columns ("Förändring" & "Utgående") per months and I would likle to summarize only one of the columns ("Förändring")
I can only find option to show Total for both columns or none of them.
Solved! Go to Solution.
Thanks!
I have unfortunately been to busy to look into this solution. It will probably work, but now the management has new requests so I will have to start all over again...
I think I will have to rethink and create a new table with the information I need.
@swe_sebastian , You can make grand total blank using isfiltered ([Year]), But if you create a calculation group, that will give better results with isfiltered and selectedmeasure
Thanks!
I have unfortunately been to busy to look into this solution. It will probably work, but now the management has new requests so I will have to start all over again...
I think I will have to rethink and create a new table with the information I need.