topic Re: Rank Month column for all null count metrics in DAX Commands and Tips

Rank Month column for all null count metrics

Priya_E — Fri, 08 Sep 2023 04:07:12 GMT

Hi Everyone- I have all months where there is no service as count null. I need to filter only the first month.

I need to create a Rank column which will rank the month column( as all the count metric is null) for each service/sub service.

Blow is the expected output if we filter top 1 rank.

Thanks!

Anonymous — Tue, 12 Sep 2023 06:19:32 GMT

You can take a look at the following blog that mention to rank based on multiple columns if this help with your scenarios:

Regards,
Xiaoxin Sheng