Compare results and provide the differnce

[sabeensp]

Hello,

I have a resulte set in two grids, I need to find what is in 1 grid and not in another. Below is the image what I'm trying to do, also you can download pbix form here:

https://1drv.ms/u/s!AumyvtVXEve9jL1EXA9FFVtboSCclw

[v-juanli-msft · Accepted solution]

Hi @sabeensp

Copy Table1 to create Table2

create measure in Table1 and Table2

measure in Table1
Measure =
LOOKUPVALUE (
    Table2[Qty],
    Table2[Location], SELECTEDVALUE ( Table2[Location] ),
    Table2[Vehicle], MAX ( Table1[Vehicle] ),
    Table2[Type], MAX ( Table1[Type] )
)
Measure 2 = IF(ISBLANK([Measure]),1,0)

measure in Table2
Measure 3 =
LOOKUPVALUE (
    Table1[Qty],
    Table1[Location], SELECTEDVALUE ( Table1[Location] ),
    Table1[Vehicle], MAX ( Table2[Vehicle] ),
    Table1[Type], MAX ( Table2[Type] )
)

Measure 4 = IF(ISBLANK([Measure 3]),1,0)

Then add  Measure/Meausre3 in the Visual level filter of the table, select "show items when value is blank

See more details in my pbix 

Best Regards

Maggie

[sabeensp]

@v-juanli-msft  can you please share your pbix?

[v-juanli-msft]

Hi @sabeensp

Update!

Sorry for inconvenience.

Best Regards

Maggie

[Greg_Deckler]

Perhaps my "Not In Common" Quick Measure will work? https://community.powerbi.com/t5/Quick-Measures-Gallery/Not-In-Common/m-p/388273

[sabeensp]

@Greg_Deckler

 So, my data is coming from the same table, and there is not relationship between othet tables.

[sabeensp]

@Greg_Decker So, my data is coming from the sam etale, and there is not relationship between othet tables.