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
Some like this
IF (
ISEMPTY (FILTER ( Finance, Finance[Line Description] IN 'Specific Rows'[ Specific Rows]) ),
"",
[measure]
)
however, you might recieve error
tamerj1 Thanks, i will try it. But, i tried something like below it won't display anything .
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.