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

DataVitalizer's avatar
DataVitalizer
Super User
3 years ago

Hi Simon3 

You are supposed to sum up the division per row, to do so create the following Measure

 

MyMeasure=
SUMX(
ALLSELECTED(MyTable[Discipline]),
DIVIDE(SUM(MyTable[DDF components]),SUM(MyTable[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

hi DataVitalizer thanks for the message, I have tried your formula but without luck, the result is not what I expected:

 

  • DataVitalizer's avatar
    DataVitalizer
    Super User
    3 years ago

    Can you share with me that first table as a data sample so I can use it to verify the fomula again?

      • DataVitalizer's avatar
        DataVitalizer
        Super User
        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