Forum Discussion
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...
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
I'm a little lost here. Do you want to show the value for the other rows as blanks or you want to entirely hide the row?
Yes!. I want to show the value of the other row as blank. Everything will be mapped to GM % only which i already have. Some like this.