Dax to produce distinct count of comments (12 comment fields) per supplier across all raters

[FM]

Hello PBI Community,

I have a supplier rating system that allows a rater to enter comments in 12 fields.  My aim is to have a distinct count of comments per supplier across all raters.  I have had difficulty with a dax expression that will provide this distinct count.  Note:  The comments fields are not mandatory, so the count will vary by each rater for each supplier.

Table below reduced to 3 columns for this example.

[edhans]

There was nothing attached, but you should unpivot those fields in Power Query so there is one comment field and it will have a common supplier code rather than one supplier code with 12 fields.

1. Load your data into Power Query - or it is already there.
2. Right-click on the Supplier field and select "unpivot other columns"
3. Rename the "Attribute" and "Value" columns as desired.

It will look like this, which DAX can easiliy handle as it is tabular.