Forum Discussion

Helper V

7 years ago

Solved

Measure 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...

Need Help

MFelix

7 years ago

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

filter_count.pbix33 KB

MFelix

Super User

7 years ago

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

filter_count.pbix33 KB