Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Need Help with a Measure Formula

Hi All,

 

I need help with a measure formula.

 

 

The Formula for Channel Mix is (Channel Volume Share AC -  Channel Volume Share Base)* (NR/hL Base - Channel Value/hL Base)*Channel Volume AC.

All of the above mentioned columns are measures.

 

At a total level (Channel Volume Share AC -  Channel Volume Share Base) is equal to 0 and (NR/hL Base - Channel Value/hL Base) is also equal to 0, but at the row level Channel Mix values are connect.

 

Is there way to write a measure formula to add total even though at the total level due to the calculations the value is 0.

 

Thanks in advance.

Kuber Kumar

 

 

Need Help
  • v-xulin-mstf's avatar
    v-xulin-mstf
    5 years ago

    Hi Anonymous

     

    What your expected output?

    You can use HASONEVALUE to define calculation logic of total.

    Try measure as:

     IF(
    HASONEVALUE(Table[column]),
    measure,
    total
)

     

    Best Regards,
    Link

     

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

2 Replies

  • v-xulin-mstf's avatar
    v-xulin-mstf
    Community Support
    5 years ago

    Hi Anonymous

     

    What your expected output?

    You can use HASONEVALUE to define calculation logic of total.

    Try measure as:

     IF(
    HASONEVALUE(Table[column]),
    measure,
    total
)

     

    Best Regards,
    Link

     

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