Forum Discussion
Figuring out this LookUp Formula
JChouris By default, slicers affect every other visual on the page. So, for example, if you select a part number of TCRH and an Invoice Year of 2022 in your slicers then only the first row of your table will be in context for the visuals on the page. This means that if you do a SUM of 3 Year Combined RGM, then the value returned would be 478 because only the first row is in context.
If you need to override the default context for something then you can use the ALL function to override the filters from the slicers.
| PartNum | InvoiceYear | 3 Year Combined Shipped | PartNum | RGMYear | 3 Year Combined RGM | |
| TCRH | 2022 | 292 | TCRH | 2022 | 478 | |
| TCRH | 2023 | 929 | TCRH | 2023 | 876 | |
| TCRH | 2024 | 1891 | TCRH | 2024 | 1130 |
I have formulas in place to calculate the 3 year running total for RGM units and Shipped units.
I want to be able to use the slicer to filter to the part number i want, the RGM Year and Invoice Year. What i am falling short on is the bar graph at the top and the forula for that. I need to Take the total Generated by the 3 Year Combined RGM and Divide it by the total for the 3 Year Invoiced to get my values in the graph. But i am unsure how to get the graph to reflect the choices on the slicer and use those values as the totals to divide. I hope that makes sense. I am fairly new to this and havevnt worked much with calculations like this.
JChouris By default, slicers affect every other visual on the page. So, for example, if you select a part number of TCRH and an Invoice Year of 2022 in your slicers then only the first row of your table will be in context for the visuals on the page. This means that if you do a SUM of 3 Year Combined RGM, then the value returned would be 478 because only the first row is in context.
If you need to override the default context for something then you can use the ALL function to override the filters from the slicers.