Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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