Show data only if item exists in all the selected years

[Andrew_pbi]

Hello Community, I am new to powerbi (trying to learn DAX) and have been faced with a scenario to calculate and display the total sales value based on the highest value of the years selected.
So in the report we have a multi select year slicer (used from Year field in the data source). There is a bar garph that shows the sum of values from "Total" filed against Region and Rep and Item hierarchy.

Now, the request is to display the graph for the items (display in the Region/Rep/Item hierarchy level) that are common with the years that are all selected in the slicer. Would it be posible to achive this?

Please can someone help me with the DAX to achieve this.

Region	Rep	Item	Units	Unit Cost	Total	Year
East	Jones	Pencil	95	1.99	189.05	2022
Central	Kivell	Binder	50	19.99	999.50	2021
Central	Jardine	Pencil	36	4.99	179.64	2021
Central	Gill	Pen	27	19.99	539.73	2025
West	Sorvino	Pencil	56	2.99	167.44	2024
East	Jones	Binder	60	4.99	299.40	2020
Central	Andrews	Pencil	75	1.99	149.25	2024
Central	Jardine	Pencil	90	4.99	449.10	2024
West	Thompson	Pencil	32	1.99	63.68	2025
East	Jones	Binder	60	8.99	539.40	2025
Central	Morgan	Pencil	90	4.99	449.10	2024
East	Howard	Binder	29	1.99	57.71	2024
East	Parent	Binder	81	19.99	1,619.19	2022
East	Jones	Pencil	35	4.99	174.65	2020
Central	Smith	Desk	2	125.00	250.00	2023
East	Jones	Pen Set	16	15.99	255.84	2021
Central	Morgan	Binder	28	8.99	251.72	2021
East	Jones	Pen	64	8.99	575.36	2020
East	Parent	Pen	15	19.99	299.85	2020
Central	Kivell	Pen Set	96	4.99	479.04	2025
Central	Smith	Pencil	67	1.29	86.43	2020
East	Parent	Pen Set	74	15.99	1,183.26	2020
Central	Gill	Binder	46	8.99	413.54	2021
Central	Smith	Binder	87	15.00	1,305.00	2022
East	Jones	Binder	4	4.99	19.96	2023
West	Sorvino	Binder	7	19.99	139.93	2023
Central	Jardine	Pen Set	50	4.99	249.50	2022
Central	Andrews	Pencil	66	1.99	131.34	2023
East	Howard	Pen	96	4.99	479.04	2021
Central	Gill	Pencil	53	1.29	68.37	2024

[SamInogic]

Hi @Andrew_pbi ,

As per our understanding, you want the graph to display items count based on Year, Region and Rep hierarchy. So, you can try below configuration with “Area Chart” type of visual (or can use any other chart as required) on the Power BI report.

Add X-axis properties with columns as Year, Region, Rep and Y-Axis as Count of Item

Please refer to the below screenshot for the same.

Let us know if your expected output in case the required output is different than this.

Thanks!

Inogic Professional Services Division

Power Platform and Microsoft Dynamics 365 CRM Development – All under one roof!

Drop an email at crm@inogic.com

Services:  http://www.inogic.com/services/

Power Platform/Dynamics 365 CRM Tips and Tricks:  http://www.inogic.com/blog/