Forum Discussion

Venkatesh_'s avatar
Venkatesh_
Helper I
2 years ago
Solved

Need 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. ...
Need Help
Show and Tell
  • Venkatesh_'s avatar
    Venkatesh_
    2 years ago

    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

      

fahadqadir3's avatar
fahadqadir3
Solution Supplier
2 years ago

Venkatesh_ In your screenshot, last line (highlighted in red) is a SUBTOTAL VALUE or a site name VALUE ? I didn't see subtotal in your image attached, share a sample dataset or clear picture. Thank you

  • Venkatesh_'s avatar
    Venkatesh_
    Helper I
    2 years ago

    fahadqadir3  First row is the sub total(row) of the product, attaching the full matrix visual, the grand total also shows zero for the meaures above,  If you see the first line, It should result approx "90.20" = (-185+90.48), same follows for variance of avg sell price as well.