Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric 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 ReportingJoin the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.
User | Count |
---|---|
89 | |
80 | |
65 | |
63 | |
60 |
User | Count |
---|---|
166 | |
114 | |
100 | |
73 | |
66 |