Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Rank in PBI

Hi all,

I want to show both  top view and bottom view content title for each news type for a selected month

I have created a dax to show top view like beloe

RANKX (

CALCULATETABLE (

VALUES ( 'Fact Content'[content_title] ),

ALLSELECTED( ( 'Fact Content'[content_title] ),

'Fact Content'[Filtered News Type])

),

'Fact Content'[Month Filter]

)

 But i am filtering it in filters section in PBI For this rank dax like is contains 1, then it's showing Top 1 rank for each news type for a selected month, but how to show bottom view 

can you please suggest something

Thanks

2 Replies

  • mlsx4's avatar
    mlsx4
    Icon for Memorable Member rankMemorable Member

    Hi Anonymous 

    You can create another rank but order it DESC and getting the top 1 too.

    • Anonymous's avatar
      Anonymous
      Not applicable

      But in above I haven't given any ascending or descending right

      and moreover Month Filter is also a dax and I cannot know what bottom rank is