Showing results for 
Search instead for 
Did you mean: 
Frequent Visitor

Compair total of two data set and if match green light

I want to compair a transformed data to another data total and if it matches I want to show a green light 🚦


I have some reports created manually and want to validate it's correctness by checking with other raw data. In power bi dashboard can we compare a total row in a data with other data and show the validation results 

Super User
Super User

Please read about INTERSECT().


Please provide sample data that covers your issue or question completely.
Please show the expected outcome based on the sample data you provided.



Helpful resources

Exciting changes

Power BI Community Changes

Check out the changes to the Power BI Community announced at Build.

May 2023 update

Power BI May 2023 Update

Find out more about the May 2023 update.

Kudo Data Story carousel

Data Stories Gallery

Visit our Data Stories Gallery and give kudos to your favorite Data Stories.

Top Solution Authors