Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hello!
I am trying to add two columns to an existing matrix. My issue is that the two columns that I want to add are NOT going to be aggregated. I have one row of values for each date, therefore no need to aggregate i.e. Sum, Average, etc. Below is a screenshot of the matrix and the two columns that I want to add to the matrix. I would like my final matrix to have the following columns:
Weekly DATE Unique Dials Total Dials Leads Cost
Solved! Go to Solution.
Hi @wfarrell,
It is a default behavior that any field added to values section of Matrix has to be aggregated. Since in your source table, there is only one date row for each date, whether it is aggregated with Sum or Max or Average, the displayed result is the same as original data which is not aggregated in table.
Regards,
Yuliana Gu
This was the solution that worked for me.
https://www.kasperonbi.com/use-isinscope-to-get-the-right-hierarchy-level-in-dax
The only limitations are that it can only be used in Azure AS or in the Power BI Service.
This came out in Nov 18 and Kasper notes that there was no existing functionality to replicate the behaviour.
Could be time to revist your measures if it suits your scenario.
Regards
Hi @wfarrell,
It is a default behavior that any field added to values section of Matrix has to be aggregated. Since in your source table, there is only one date row for each date, whether it is aggregated with Sum or Max or Average, the displayed result is the same as original data which is not aggregated in table.
Regards,
Yuliana Gu
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.