SQL to DAX conversion

[Anonymous]

Hello All,

I want to create a new calcualted table from existing source table. Since my source is excel, I cannot use direct SQL query. I have the SQL query but struggling to make up a DAX version.

Below is the query:
select companies,cluster,
cast(cast(individualcount as decimal(10,2))/cast(totalcount as decimal(10,2))*100 as decimal(10,2)) as Percentage
from
(select a.companies,a.cluster,a.count,b.totalcount from
(select companies,cluster,count(cluster) as individualcount from table
group by companies,cluster)a
inner join
(select cluster,count(cluster) as totalcount from table
group by cluster)b
on a.cluster=b.cluster)tb

Looking forward to your suggestions.

Thanks in advance.

[v-piga-msft]

Hi @Anonymous ,

Have you solved your problem?

If you have solved, please always accept the replies making sense as solution to your question so that people who may have the same question can get the solution directly.

If you still need help, please share more details.

Best  Regards,

Cherry

[v-piga-msft · Accepted solution]

Hi @Anonymous ,

You could refer to this article to undesrtand how to convert SQL to Dax.

If you still need help, please share your data sample which could reproduce your scenario and your desired output so that we could help further on it.

Best  Regards,

Cherry