count product, item and country

[pardeepd84]

Hi,

I need to get the count of the following columns:

- product

- item

- country

Please could you let me know how to get a measure to count all 3 columns.

[v-jayw-msft · Accepted solution]

Hi @pardeepd84 ,

To get the sum of count value of each column.

Measure = DISTINCTCOUNT('Table'[country])+DISTINCTCOUNT('Table'[item])+DISTINCTCOUNT('Table'[product])

To show the count of each column in a measure.

Measure = DISTINCTCOUNT('Table'[country])&" country,"&DISTINCTCOUNT('Table'[item])&" item,"&DISTINCTCOUNT('Table'[product])&" product"

Best Regards,

Jay

[amitchandak]

@pardeepd84 ,

if you need distinctcount

countrows(summarize (Table, Table[product], Table[Item], Table[Country]))

for count

countrows(selectcolumns(Table, "Combine",Table[product]& Table[Item] &Table[Country]))