Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to Solution.
@Anonymous ,
You may try CALCULATETABLE in RANKX.
@Anonymous ,
You may try CALCULATETABLE in RANKX.
any ideas ?
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
99 | |
80 | |
64 | |
57 |
User | Count |
---|---|
143 | |
109 | |
89 | |
84 | |
66 |