Skip to main content

Power BI

Needs Votes

Allow to concatenate within the DISTINCTCOUNT

Vote (2) Share
Power BI User's profile image

Power BI User on 24 Jun 2020 21:57:35

I had been using Tableau for 2 years of my career and have switched to Power BI within my current position as a BI Developer. In Tableau, when I wanted to do a count distinct of two or more columns I was able to use COUNTD([Column1]+[Column2]).

It would be really useful to be able to create in Power BI, DISTINCTCOUNT('Table'[Column1]&'Table'[Column2]) without having to create an extra column in the data model which concatenates the two.