Percent Difference between two visuals utilizing slicers and two different tables

[JCATERINO]

Can someone please help:

1. I created two tables that are filtered by several slicers - Month, Year, Site and Class of Work

2. Both cards display the distinct count of Orders completed based on the slicers

3. I would like to create a visual card that calculated the percent difference between the two cards

Example

First Card returns 352 orders for 2025, Site A, Class of Work A

Second Card returns 645 orders for 2024, Site A, Class of Work A

I would like to calculate the percent difference based on the slicers so it would filter dynamically.

[v-lgarikapat]

Hi @JCATERINO ,

Thanks for reaching out to the Microsoft fabric community forum.

Could you please provide sample data that fully represents the issue or question you're referring to? Kindly ensure the data is in a usable format (e.g., Excel or CSV) rather than a screenshot, and does not contain any sensitive or unrelated information.

Looking forward to your response.

Best regards,
Lakshmi Narayana

[JCATERINO]

Hello Lakshmi

Table 1 Slicers
Filter Month	Completed Year	Order Site	Class of Work	Distinct Count
1	2024	A	A	5

Table 2 Slicers
Filter Month	Completed Year	Order Site	Class of Work	Distinct Count
1	2025	A	A	3

What I like to return
Percent Differenct		-40

Here is an example table - the table is duplicated so I can use slicers for each table to return the distinct count value like the example above

Order Name	Month Completed	Order Completed Year	Order Site	Class of Work
20NAR001	1	2024	A	A
20NAR001	1	2024	A	B
20NAR001	2	2024	A	C
20NAR002	1	2024	A	A
20NAR002	2	2024	A	B
20NAR002	1	2024	A	C
20NAR003	1	2024	A	A
20NAR003	1	2024	A	B
20NAR003	2	2024	A	C
20NAR004	2	2024	A	A
20NAR004	2	2024	A	B
20NAR004	2	2024	A	C
20NAR005	1	2024	A	A
20NAR005	1	2024	A	B
20NAR005	1	2024	A	C
20CMR001	2	2024	A	A
20CMR001	2	2024	A	B
20CMR001	1	2024	A	C
20CMR002	2	2024	A	A
20CMR002	1	2024	A	B
20CMR002	1	2024	A	C
20CMR003	1	2024	A	A
20CMR003	2	2024	A	B
20CMR003	2	2024	A	C
21NAR001	2	2025	A	A
21NAR001	1	2025	A	B
21NAR001	1	2025	A	C
21NAR002	2	2025	A	A
21NAR002	2	2025	A	B
21NAR002	2	2025	A	C
21NAR003	1	2025	A	A
21NAR003	1	2025	A	B
21NAR003	2	2025	A	C
21CMR001	1	2025	A	A
21CMR001	1	2025	A	B
21CMR001	2	2025	A	C
21CMR002	2	2025	A	A
21CMR002	1	2025	A	B
21CMR002	1	2025	A	C
21CMR003	1	2025	A	A
21CMR003	2	2025	A	B
21CMR003	2	2025	A	C
21CMR004	2	2025	A	A
21CMR004	2	2025	A	B
21CMR004	1	2025	A	C

[v-lgarikapat]

HIi @JCATERINO ,

Thank you for your prompt responses and for sharing the sample data.

I’ve implemented the required logic and uploaded the updated  PBIX file for your review. Kindly take a moment to go through it and let me know if there’s anything that needs to be revised or improved.

Looking forward to your feedback.

Best regards,
Lakshmi