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.
I have 2 tables. One is a fact table (monthly expenses) the other is a monthly budget. After I create a merge of the two data tables, in the matrix, the values for the budget is either missing or sums up the budget incorrectly. It doesnt want to sit side by side by months on the matrix. I tried everything, create a index and its doesnt work. I just dont understand what could be wrong.
Its not the data, I checked countless times. Its how PowerBi is reading the values.
Hi @Anonymous ,
Do you mean that in the matrix Totar is incorrect, You can create a Measure, use HASONEVALUE and IF to make judgments, and make sure Total is correct.
Here are the steps you can follow:
1. Create measure.
Measure =
var _sum=
SUMMARIZE('Table','Table'[MonthName],"Value",SUM('Table'[Value]))
return
IF(
HASONEVALUE('Table'[Index]),MAX('Table'[Value]),SUMX(_sum,[Value]))
2. Result:
If I have misunderstood your meaning, please provide your pbix file without privacy information and desired output.
Best Regards,
Liu Yang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly
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.