Forum Discussion
Compare, evaluate, and visualize “mismatched” data across a table
PortoIvan Did you mean that for B that the mismatch is "Price Found"? If that is the case, then you could do this:
Complex Selector = VAR __Member = MAX('Table'[Member ]) VAR __Category = MAX('Table'[Category ]) VAR __Table = SUMMARIZE(FILTER(ALL('Table'),[Member ] = __Member),[Category ],"__Count",COUNTROWS('Table')) VAR __Min = MINX(__Table,[__Count]) VAR __MinCategory = MINX(FILTER(__Table, [__Count] = __Min),[Category ]) RETURN IF(__Category = __MinCategory,1,0)
Greg_Deckler Unfortunately no, because although that would work for one member for another member a category of "Price Match" might not be the "mismatch". For example using the same table I provided Member B ordered Item 23-111 multiple times, however in their case the mismatch is the 1 purchase they made where the item had a category of Price Match, since No Price Found occurred twice where as Price Match occurred once.
Community ChampionPortoIvan Did you mean that for B that the mismatch is "Price Found"? If that is the case, then you could do this:
Complex Selector =
VAR __Member = MAX('Table'[Member ])
VAR __Category = MAX('Table'[Category ])
VAR __Table = SUMMARIZE(FILTER(ALL('Table'),[Member ] = __Member),[Category ],"__Count",COUNTROWS('Table'))
VAR __Min = MINX(__Table,[__Count])
VAR __MinCategory = MINX(FILTER(__Table, [__Count] = __Min),[Category ])
RETURN
IF(__Category = __MinCategory,1,0)
Greg_Deckleryour correct I meant the mismatched occurred where the category for one of the three purchases made by member B was "Price Match" I edited my previous reply.
- Greg_Deckler
PortoIvan I edited my reply also with what I believe is the solution.