Rank Month column for all null count metrics

[Priya_E]

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!

[v-shex-msft · Accepted solution]

HI @Priya_E,

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

RANKX on multiple columns with DAX and Power BI - SQLBI

Regards,
Xiaoxin Sheng