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
Hi Anonymous
Create 'Specific Rows' Table or import it from it from excel. Then create a measure
Filter Measure =
COUNTROWS ( FILTER ( Finance, Finance[Line Description] IN 'Specific Rows'[ Specific Rows]) )
Place this measure in the filter pane of the table visual and select "Is not blank" and apply the filter.
tamerj1 Please read my post. I want Budget/Actual. but, I want the % to be on specific row.. which i posted. They are other row but, i want % to be on specific row while other rows remain the same.
Here are the specific i wanted the % on.
| Baked Goods Gross Margin (31290) % |
| Baked Goods Gross Margin (31290) % |
| Cold Disp Beverage Gross Margin (31294) % |
| Cold Grab & Go Gross Margin (37969) % |
| Frozen Disp Beverage Gross Margin (31295) % |
| FS Prep on Site Gross Margin (31293) |
| Hot Disp Beverage Gross Margin (31296) |
| Hot Foods Gross Margin (37968) |
| Other Food Service Gross Margin (31292) |
| Other Retail Food Service Gross Margin (37970) |
| QSR Gross Margin (31297) |
| Baked Goods Gross Margin (31290) |
| Baked Goods Gross Margin (31290) |
| Cold Disp Beverage Gross Margin (31294) |
| Cold Grab & Go Gross Margin (37969) |
| Frozen Disp Beverage Gross Margin (31295) |
| FS Prep on Site Gross Margin (31293) |
| Hot Disp Beverage Gross Margin (31296) |
| Hot Foods Gross Margin (37968) |
| Other Food Service Gross Margin (31292) |
| Other Retail Food Service Gross Margin (37970) |
| QSR Gross Margin (31297) |
Roller Grill Gross Margin (31291)
|