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

      

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi Venkatesh_ ,

 

Thanks for the reply from fahadqadir3 , please allow me to provide another insight: 

 

It seems that it may be a problem with the measure total. You can use the ISINSCOPE function to control different levels to show different results.

 

Measure =
IF(ISINSCOPE(financials[Product]),"aaa",IF(ISINSCOPE('financials'[Country]),"bbb"))

 

 

In addition, these links may be helpful to you:

Dealing with Measure Totals - Microsoft Fabric Community

Measure Totals, The Final Word - Microsoft Fabric Community

 

If your Current Period does not refer to this, please clarify in a follow-up reply.

 

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.

  • Venkatesh_'s avatar
    Venkatesh_
    Helper I
    2 years ago

    Anonymous  It seems like I cannot use the INSCOPE function in my measure, attaching the snap for your reference

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      2 years ago

      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.

      • Venkatesh_'s avatar
        Venkatesh_
        Helper I
        2 years ago

        Can you send me the revised measure please? I can't achieve yet.