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
tamerj1 Your DAX works, But, i want the % to display only on the listed row not on other rows. right now it still display on other rows.
Hi Anonymous
then use
IF (
ISEMPTY (FILTER ( Finance, Finance[Line Description] IN 'Specific Rows'[ Specific Rows]) ),
[measure],
""
)
however, you might recieve error