Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

DAX CALCULATION

I'm trying to GM % on a row based. Net GP/Sales. Please can someone help me.   
Need Help
amitchandak's avatar
amitchandak
Super User
4 years ago

Anonymous , A measure like

divide(calculate([Measure], filter(Table, search("Net GP",Table[Line Description],,0) >0) ) ,

calculate([Measure], filter(Table, search("Sales",Table[Line Description],,0) >0) ) )