Hello,
Based on table below, I wish to create two measures 'total_metric1' and 'total_metric2'. However, the correct total as per my use case for total_metric1 = 500 and total_metric2 = 1700. At the moment, PBI is totaling it as 1000 and 3400 respectively.
How can I achieve this optimally via DAX?
So if you add 01B or 02B to a card visual, they work.
However, if you try to add them to the table visual, you get the following error:
"SummarizeColumns() and AddMissingItems() may not be used in this context."
That's annoying.
The following link provides guidance that we should replace SUMMARIZECOLUMNS with ADDCOLUMNS+SUMMARIZE.
So I have modified the code here in 01C & 02C.
As a result, these now work correctly within the table visual, as shown.
Regards,
Nathan
So if you add 01B or 02B to a card visual, they work.
However, if you try to add them to the table visual, you get the following error:
"SummarizeColumns() and AddMissingItems() may not be used in this context."
That's annoying.
The following link provides guidance that we should replace SUMMARIZECOLUMNS with ADDCOLUMNS+SUMMARIZE.
So I have modified the code here in 01C & 02C.
As a result, these now work correctly within the table visual, as shown.
Regards,
Nathan
Helpful resources
Join us at the Microsoft Fabric Community Conference
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
Microsoft Fabric Community Conference 2025
Arun Ulag shares exciting details about the Microsoft Fabric Conference 2025, which will be held in Las Vegas, NV.
A Year in Review - December 2024
Find out what content was popular in the Fabric community during 2024.
