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
