Forum Discussion

I_Like_Power_BI's avatar
6 years ago
Solved

Dynamic Slicer Default Based on Top N

Hi all!   I have a report that uses RLS to determine whether someone has the data either a.) restricted to their data set, b.) restricted to their team data set, or c.) not restricted at all (admin...
  • amitchandak's avatar
    amitchandak
    6 years ago

    I_Like_Power_BI , This column has all the values and one value default value. So means it will keep on getting all the values. Now has this column does not have account no for the first account

     

    minx(allselected(Table),Table[Account]) 

    Will give you the min Account number. You can use that measure in title to display the selected account No.