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

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.