Forum Discussion

vividarinda's avatar
vividarinda
Icon for Helper II rankHelper II
2 years ago

Dax Count Row Number Over Partition on Power BI

Hello,

 

I am trying to convert the SQL stetment to DAX

SELECT COUNT(*) as totalrow from (
select DW."DW_FILTER_CUT_TRANSPOSE".*, row_number() over(partition by unitno,attribute order by sampledate desc) as rn from "DW_FILTER_CUT_TRANSPOSE"
) tt
where rn = 1