Forum Discussion

jenneferparr's avatar
jenneferparr
Icon for Helper I rankHelper I
6 years ago
Solved

If-Then Measure doesn't total correctly

I have a table where I've created 3 measures to calculate a 4th measure using an if statement. I have two problems but specifically need help getting that if statement to total correctly. Here are m...
Need Help
  • v-xicai's avatar
    v-xicai
    6 years ago

    Hi jenneferparr ,

     

    You may create a new measure like DAX below, assuming the field in Rows box of Matrix visual is Table1[Product ID].

     

    CALCBF_New =
VAR _table =
    SUMMARIZE ( Table1, Table1[Product ID], "_Value", [CALCBF] )
RETURN
    IF ( HASONEVALUE ( Table1[Product ID] ), [CALCBF], SUMX ( _table, [_Value] ) )

    Best Regards,

    Amy 

     

    Community Support Team _ Amy

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hi jenneferparr ,

 

Can you share the entire screen shot.

 

Not very clear as to what happened.

 

Also share a sample file if possible.

 

Regards,

HN

jenneferparr's avatar
jenneferparr
Icon for Helper I rankHelper I
6 years ago

Here is the full matrix:

and here is the measure with your changes:

 

Maybe I mistyped something? Unfortunately I can't share the file for confidentiality reasons. 

The two tables included in these measures are related one-to-many on LOADID.

  • v-xicai's avatar
    v-xicai
    Icon for Community Support rankCommunity Support
    6 years ago

    Hi jenneferparr ,

     

    You may create a new measure like DAX below, assuming the field in Rows box of Matrix visual is Table1[Product ID].

     

    CALCBF_New =
VAR _table =
    SUMMARIZE ( Table1, Table1[Product ID], "_Value", [CALCBF] )
RETURN
    IF ( HASONEVALUE ( Table1[Product ID] ), [CALCBF], SUMX ( _table, [_Value] ) )

    Best Regards,

    Amy 

     

    Community Support Team _ Amy

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.