Forum Discussion
Need help in dax while using matrix visual - Row total is not giving me the correct result
Anonymous Thanks for your reply. Still, your measure is missing overall total row value. Here is the correct measure which helps me to acheieve desired result
Proj. Annual Var =VAR PYI1 = [Predicted Year Income 1]VAR PYI2 = [Predicted Year Income 2]VAR Result =IF(ISINSCOPE(Sites[Name]) && ISINSCOPE(BITransactions[ProductName]),PYI1 - PYI2,SUMX(SUMMARIZE(BITransactions,Sites[Name],BITransactions[ProductName],"Diff", [Predicted Year Income 1] - [Predicted Year Income 2]),[Diff]))RETURN Result
Hi Venkatesh_ ,
This function is ISINSCOPE instead of INSCOPE. Also, please check whether the difference between your two numbers in the parent level is 0. If it is 0, you need to rewrite the calculation for it and then use the ISINSCOPE function to return its value.
Best Regards,
Clara Gong
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Can you send me the revised measure please? I can't achieve yet.
Hi Venkatesh_ ,
Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data. We can better understand the problem and help you.
Best Regards,
Clara Gong
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi Anonymous Attaching the PBIX sample file link for your reference. It says the problem with the matrix visual on Proj annual variance and variance on sell price. You wont see any sub total or total rows and if you see they are adding incorrect results. Thanks.
Sample PBI link:
https://drive.google.com/drive/folders/1pXfcLfmEDZ0uaRRncSCeBIIBFSaVR_TI?usp=sharingAnonymous any update on this problem please?