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 ,

 

 

Try this measure

 

CALCBF =
SUMX (
    'T_LOAD_DETAIL',
    IF (
        T_LOAD_DETAIL[BF_Net] = 0,
        T_LOADS[NetTonToMBF] * 1000,
        T_LOAD_DETAIL[BF_Net]
    )
)

 

 


Regards,

Harsh Nathani


Appreciate with a Kudos!! (Click the Thumbs Up Button)

Did I answer your question? Mark my post as a solution!

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

    Thanks Anonymous, I tried that and it removed the row totals for all but one product ID. 

     

     

    • 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.