Forum Discussion
Venkatesh_
Helper I
Helper INeed help in dax while using matrix visual - Row total is not giving me the correct result
Can anyone of you help me to figure out why my subtotals are not populating here please? If i add the all selected to the product level still it end up giving me the wrong result in matrix visual. ...
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
Venkatesh_Helper I
Helper IHi 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=sharing
Venkatesh_Helper I
Helper IAnonymous any update on this problem please?