Forum Discussion
NBOnecall
Helper V
Helper VMeasure to Show Duplicates in a Matrix Visual
Hi, I have the below data in a matrix and I would like to only show the duplicates. I have tried to use this formula, Measure = CALCULATE(counta('ns SettlementItemPrice'[FixedSKU]),ALL...
Hi NBOnecall ,
Create the following measure:
CountRows = MAXX ( ADDCOLUMNS ( SUMMARIZE ( SKU; SKU[FixedSKU]; SKU[Fee]; SKU[Price] ); "CountRows"; CALCULATE ( COUNTROWS ( SUMMARIZE ( SKU; SKU[FixedSKU]; SKU[Fee]; SKU[Price] ) ); ALLEXCEPT ( SKU; SKU[FixedSKU] ) ) ); MAX ( [CountRows] ) )Then add it to the filter pane and select all values different from 1.
See attach PBIX.
Regards,
MFelix
NBOnecallHelper V
Helper VSo please see the first picture, this is the raw data.
These would be the visualizations as the table of data is being summed on the quantity with a Measure to count how many lines are in the visualization witht the same SKU.
The expected out put would be the final image, after filtering out the rows with 1 count for the measure.
Thanks.
MFelix
Super User
Super UserHi NBOnecall ,
Create the following measure:
CountRows =
MAXX (
ADDCOLUMNS (
SUMMARIZE ( SKU; SKU[FixedSKU]; SKU[Fee]; SKU[Price] );
"CountRows"; CALCULATE (
COUNTROWS ( SUMMARIZE ( SKU; SKU[FixedSKU]; SKU[Fee]; SKU[Price] ) );
ALLEXCEPT ( SKU; SKU[FixedSKU] )
)
);
MAX ( [CountRows] )
)
Then add it to the filter pane and select all values different from 1.
See attach PBIX.
Regards,
MFelix