Forum Discussion

JustaRookie012's avatar
JustaRookie012
Frequent Visitor
2 years ago
Solved

Question regarding fixed value

Dear community,   I have the following simplified Table Company Project Period Value1 Value2 A A 13 10 20 A A 13 10 20 A B 13   20 A B 13   20 A C 13 10 2...
  • EylesIT's avatar
    EylesIT
    2 years ago

    JustaRookie012, here is my suggested solution.

    Change the DAX of your Result measure to this:

    Result = 
    CALCULATE(
        DIVIDE(SUM(YourTable[Value1]), SUM(YourTable[Value2])),
        ALL(YourTable)
    )

     

    This gives me the following output:

     

EylesIT's avatar
EylesIT
Resolver II
2 years ago

JustaRookie012, here is my suggested solution.

Change the DAX of your Result measure to this:

Result = 
    CALCULATE(
        DIVIDE(SUM(YourTable[Value1]), SUM(YourTable[Value2])),
        ALL(YourTable)
    )

 

This gives me the following output: