Count unique values if > 1

Hi I have a table that contains Property ref, Trad, Supplier and unique. The unique is a concatenation of Property-Trade-SupplierI have a report that filters by Suppplier. I am tryng to count th...

Need Help

Jihwan_Kim

4 years ago

Hi,

Please check the below picture and the attached pbix file.

Countrows meausre greater than one: =
COUNTROWS (
    SUMMARIZE ( FILTER ( Data, [Countrows measure:] > 1 ), Data[Unique] )
)

cottrera.pbix19 KB

Forum Discussion

Count unique values if > 1

Related content

Unique Count in Row convert

Count unique values

Count unique Values in a month

Count Unique Rows

Count unique values