Forum Discussion

Anonymous

Not applicable

4 years ago

Solved

Row context Filter

I need help calculating Gross Margin from Between Budget & Actual Based on my specific row on my Column. Here is my query Gross Margin = IF( HASONEFILTER(Finance[Line Description]), DIVIDE([Actu...

tamerj1
4 years ago
Hi v-xiaotang
this was answered in another post
https://community.powerbi.com/t5/DAX-Commands-and-Tips/Dax-CALCULATION-ISSUE/m-p/2485927#M68256

Anonymous

Not applicable

4 years ago

tamerj1 The Specific rows is part of the Line Description. Line Desc is the column name.

tamerj1

Community Champion

4 years ago

Yes. You should have them in a separate single column table. Of course you should use the real name of this column and its table.

Forum Discussion

Row context Filter

Related content

Filter on Visual Row Context

Is row context value in filter context list

Remove Row context without removing Filter Context

Remove visual filter context

Row & Filter Context / DAX formula