SQL to DAX conversion

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.