Forum Discussion

JCATERINO's avatar
JCATERINO
New Member
1 year ago
Solved

Percent Difference between two visuals utilizing slicers and two different tables

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...
Need Help
JCATERINO's avatar
JCATERINO
New Member
1 year ago

Hello Lakshmi

 

Table 1 Slicers
Filter MonthCompleted Year Order SiteClass of WorkDistinct Count
12024AA5

 

Table 2 Slicers
Filter MonthCompleted Year Order SiteClass of WorkDistinct Count
12025AA3

 

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 NameMonth CompletedOrder Completed YearOrder SiteClass of Work
20NAR00112024AA
20NAR00112024AB
20NAR00122024AC
20NAR00212024AA
20NAR00222024AB
20NAR00212024AC
20NAR00312024AA
20NAR00312024AB
20NAR00322024AC
20NAR00422024AA
20NAR00422024AB
20NAR00422024AC
20NAR00512024AA
20NAR00512024AB
20NAR00512024AC
20CMR00122024AA
20CMR00122024AB
20CMR00112024AC
20CMR00222024AA
20CMR00212024AB
20CMR00212024AC
20CMR00312024AA
20CMR00322024AB
20CMR00322024AC
21NAR00122025AA
21NAR00112025AB
21NAR00112025AC
21NAR00222025AA
21NAR00222025AB
21NAR00222025AC
21NAR00312025AA
21NAR00312025AB
21NAR00322025AC
21CMR00112025AA
21CMR00112025AB
21CMR00122025AC
21CMR00222025AA
21CMR00212025AB
21CMR00212025AC
21CMR00312025AA
21CMR00322025AB
21CMR00322025AC
21CMR00422025AA
21CMR00422025AB
21CMR00412025AC
v-lgarikapat's avatar
v-lgarikapat
Community Support
1 year ago

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