Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

How to Filter Rankx Function

Hi all

 

I have a measure like that  (create rank number to customer with their overdue)
Measure = IF(HASONEFILTER(Overdue[Customer Text]);RANKX(ALLSELECTED(Overdue[Customer Text]);[Local_net_Overdue];;DESC;Dense))

I have a date dimension table to make filter this visual. Theese two tables (Overdue and Date tables) are joined.

 

I can make filter when i use slicer filter visual with date table but i don't want to make filter with slicer i want to embedded code to measure then i will cancel interaction between slicer and visual (which measure used). 

I think need something like 'selectedvalue' function. I think i need a code like that --> FILTER(dim_date;SELECTEDVALUE(dim_date[Month])=dim_date[Month]) but i don't know how can i combine this code with my measure. 

I tried to explain detailed. if it's not enough i can create example data set and pbix.

I hope somebody can help me immediately