Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Divide All Values Based on Column While Respecting Filter Context in Pivot Table

  Hi all,   First post, hope everyone is well 😊   I have a relatively simple query, but unsure of how to go about constructing a DAX expression.   Probably easier to explain with a simple exa...
kitgo2's avatar
kitgo2
Advocate I
4 years ago

try -- you would just need to replace Revenue with Sales for the sales measure:

 

#Revenue = Calculate(Divide(CALCULATE(sum(Pivot[Value]),Pivot[Type]="Revenue", Allexcept(Pivot,Pivot[Company])),CALCULATE(sum(Pivot[Value]),Pivot[Type]="Number", Allexcept(Pivot,Pivot[Company])),0),ALLEXCEPT(Pivot,Pivot[Company]))
  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Hi kitgo2  thanks a lot for this, let me a give it a try and will come back to you.