Forum Discussion

Simon3's avatar
Simon3
Frequent Visitor
3 years ago
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...
Need Help
  • DataVitalizer's avatar
    DataVitalizer
    3 years ago

    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

Simon3's avatar
Simon3
Frequent Visitor
3 years ago

DataVitalizer I know that I marked the thread as resolved but can I ask an additional question related to this topic?
I went on and created a new measure as per below: 

If I remove the column discipline from the second table all the PV2 values become strange, any idea why? 
If this post is against the rule I will open a new thread.