topic Divide with Filter in DAX Commands and Tips

Divide with Filter

peterso — Tue, 22 Sep 2020 00:25:57 GMT

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 — Tue, 22 Sep 2020 01:40:30 GMT

Try like

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

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