Forum Discussion
Anonymous
4 years agoNot applicable
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...
- 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
tamerj1
4 years agoCommunity Champion
Anonymous
Some like this
IF (
ISEMPTY (FILTER ( Finance, Finance[Line Description] IN 'Specific Rows'[ Specific Rows]) ),
"",
[measure]
)
however, you might recieve error