Selected value and field parameters

[Chrisw97]

Hi,

I'm working on a report for the following purpose: next month, we will release a new version of our software tool. With Power BI, I want to check if the migration went well, that is, if the new database has the same values as the old database. We are currently running a test environment. I'm building the report but I'm facing a problem.

My goal is to compare values from the table of the old version (Prod_Pompen) with the values of the new/test version (Acc_pompen).

I prefer to create a report where I can select the columns I want to compare. Here’s what I’ve done so far:

First, I created two field parameters that contain the columns of each table (Parameter_prod & Parameter_acc).

Then, I created a measure to compare the parameters:

Vergelijking parameter =

var prod = SELECTEDVALUE('Parameter prod'[Parameter prod Fields])

var acc = SELECTEDVALUE('Parameter acc'[Parameter acc Fields])

RETURN

IF( prod = acc;"Match";"No Match")

After that, I added two slicers in the report and applied the parameters to each slicer. I want to click the columns in these slicers to compare the selected columns with each other in a table that only shows "No match". The problem is that currently all the fields show the result of the measure as "no match".

Can someone help me out?

[v-zhangti]

Hi, @Chrisw97 

Can you provide sample data for testing? Sensitive information can be removed in advance. What kind of expected results do you expect? You can also show it with pictures or Excel. I look forward to your response.

Best Regards,

Community Support Team _Charlotte

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.