Forum Discussion
Solved
dynamic division DAX column
Hi everyone, I am still new to Powerbi and I can't get around the calculate function well... I have the following table: my goal is to have a column that returns the correct division (sum of D...
I guess this measure is suffisant, but this will not give 2.63 in total
MyMeasure =
DIVIDE(
SUM(exampledataset[DDF components]),SUM(exampledataset[DD1 components]))Did it work ? 👍 A kudos would be appreciated 📢 Mark it as a solution to help spreading knowledge
Can you share with me that first table as a data sample so I can use it to verify the fomula again?
Sure, here you go! https://we.tl/t-Bz9gldCOCI
I guess this measure is suffisant, but this will not give 2.63 in total
MyMeasure =
DIVIDE(
SUM(exampledataset[DDF components]),SUM(exampledataset[DD1 components]))Did it work ? 👍 A kudos would be appreciated 📢 Mark it as a solution to help spreading knowledge