Power BI Concatenate and count the columns?

[sonuojha1]

Greetings.

Is power bi has lots of limitations to do even small calculations?

I was trying to do simple calculation  with concatenating and counting. It couldn't recognize the 2nd column.

The same in Oracle BI we can easily manage without creating any pysical column to store this in table.

Oracle BI: ----> "count(distinct "Table1"."Login ID"||"Table1"."COMPANY")"

Could some one help me to solve it. How to achive this in Power BI without creating any additional column in table..

Regards,

Sonu

[SpiroswayGR]

@sonuojha1 

Hey,

Did you try from transformation data to merge columns here ?

As for distict count, you can use it when you will create your unique identifier.

https://docs.microsoft.com/en-us/dax/distinctcount-function-dax

Don't forget to give thumbs up 👍and accept this as a solution if it helped you.

[amitchandak · Accepted solution]

@sonuojha1 , We do not have distinctCOUNTX , where you can have expression, so you need that.

You can try

countrows(Summarize(Table,Table[Login ID] , Table[COMPANY]) )

or You can create a new column and do a distinct count

new column = Table[Login ID] & Table[COMPANY]

distinctCOUNT([new column])

[sonuojha1]

Thanks Amit for quick reply.