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
Fabric Community Update - November 2024
Find out what's new and trending in the Fabric Community.
Be one of the first to start using Fabric Databases
Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.
Join us at the Microsoft Fabric Community Conference
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
Power BI Monthly Update - November 2024
Check out the November 2024 Power BI update to learn about new features.
