Need Help with a Measure Formula

[Anonymous]

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

[v-xulin-mstf · Accepted solution]

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.

[amitchandak]

@Anonymous , You have to try a measure like

new 001 channel Mix =sumx(Summarize(Table, Table[country], Table[channel], "_1", [001 channel Mix]), [_1])

https://www.youtube.com/watch?v=ufHOOLdi_jk