Forum Discussion

Chrisblanc's avatar
Chrisblanc
Regular Visitor
7 years ago
Solved

Division with active filter

Hello everyone,    I am currently struggling with what actually appears quite simple:  As you can see on the screeshots below, I have different amounts distributed per category on a graph, and the...
  • Anonymous's avatar
    Anonymous
    7 years ago

    Hey,

     

    This should work.... normally.

    SUM('Table_1'[Quantity orders])/calculate(SUM('Table_1'[Quantity orders]);all(Table_1'[Global]))

     

    Let me know how it turned out / mark it as solved if it works for you.