Forum Discussion
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
Memorable Member
Hi Anonymous
You can create another rank but order it DESC and getting the top 1 too.
- AnonymousNot 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