Forum Discussion

peterso's avatar
peterso
Helper II
5 years ago
Solved

Divide with Filter

Hi guys,

 

Wondering how I can Divide with a filter - below is a dateset example.

I'd like to divide the sum of B by the sum of C.

 

Expected result should be 37.5% - what is the best / most efficient approach with DAX?

 

 

Thanks in advance!

 

 

  • amitchandak's avatar
    amitchandak
    5 years ago

    peterso ,

     

    Try like

    divide(calculate(sum(Table[value]),Table[Category]="B"),calculate(sum(Table[value]),Table[Category]="C"))

     

    or

    divide(calculate(sum(Table[value]),filter(Table,Table[Category]="B")),calculate(sum(Table[value]),filter(Table,Table[Category]="C")))

1 Reply

  • amitchandak's avatar
    amitchandak
    Super User
    5 years ago

    peterso ,

     

    Try like

    divide(calculate(sum(Table[value]),Table[Category]="B"),calculate(sum(Table[value]),Table[Category]="C"))

     

    or

    divide(calculate(sum(Table[value]),filter(Table,Table[Category]="B")),calculate(sum(Table[value]),filter(Table,Table[Category]="C")))