Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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.
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.
It will look like this, which DAX can easiliy handle as it is tabular.
DAX is for Analysis. Power Query is for Data Modeling
Proud to be a Super User!
MCSA: BI Reporting