Forum Discussion
Solved
Compare, evaluate, and visualize “mismatched” data across a table
Hello! I have been trying for weeks to figure out the best way to determine then visualize the occurrence of what I call mismatched data within a table. consider my sample data below in the...
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
Community Champion
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.