Forum Discussion
Count Distinct Across Multiple Columns in PowerBI
Thank you, Ritaf1983 , lmolus , and lbendlin , for your responses.
Hi sajtx725,We sincerely appreciate your inquiry through the Microsoft Fabric Community Forum.
In addition to the responses provided by Ritaf1983 , lbendlin , and lmolus , kindly find attached a sample PBIX file and a screenshot for your reference. To obtain the distinct count of combinations across multiple columns such as Product, Category, and Subcategory, we have created a calculated column by concatenating these fields using the "&" operator, and then applied a DISTINCTCOUNT measure on that column.
We hope that the information provided will assist in resolving your issue. Should you have any further questions or require additional assistance, please feel free to reach out to the Microsoft Fabric Community.
Thank you.
Thank you, Ritaf1983 , lmolus , and lbendlin , for your responses.
Hi sajtx725,
We sincerely appreciate your inquiry through the Microsoft Fabric Community Forum.
In addition to the responses provided by Ritaf1983 , lbendlin , and lmolus , kindly find attached a sample PBIX file and a screenshot for your reference. To obtain the distinct count of combinations across multiple columns such as Product, Category, and Subcategory, we have created a calculated column by concatenating these fields using the "&" operator, and then applied a DISTINCTCOUNT measure on that column.
We hope that the information provided will assist in resolving your issue. Should you have any further questions or require additional assistance, please feel free to reach out to the Microsoft Fabric Community.
Thank you.
This worked for me, Thanks.