Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
I'm looking for a way to change messages based on different drill down levels in a bar chart. My hierarchy is Trade, Manager, Representative, State, Market, Vendor.
This is my DAX formula so far...
Selected = VAR Selected = FIRSTNONBLANK(Trade[Contrel Trade],TRUE) VAR selected_trade = FIRSTNONBLANK(Trade[Contrel Trade],TRUE)
VAR selected_Manager_Name = FIRSTNONBLANK('Contrel Manager'[MANAGER_NAME],TRUE)
VAR topvolumebyMarket =MAXX(SUMMARIZECOLUMNS(Dispatch[MANAGER_NAME],Dispatch[MARKET],
"MaxDispVolume",Dispatch[Disp Count]),[MaxDispVolume])
RETURN
IF(HASONEVALUE('Contrel Manager'[MANAGER_NAME]), selected_Manager_Name & "'s largest dispatch volume is in Market " & FORMAT(topvolumebyMarket,"###,0"),"PICK SOMETHING!!!")
The return statement works if I go to that layer in the chart, but I lose it if I use the 'Drill Down' feature. I can't seem to get any of the other layers to respond either. ANy help is greatly appreciated!!!
Drill down does not change filter context, so your measures won't update. I thought the standard headings auto updated during drill through
I'm not using standard headings...I'm using a card to call out specific information based on the drill down. Another words...it would be a dynamic card to say something based on selected State...the next level..I might change the message based on selected Manager...etc...
And as I said, drill down does not change filter context, so this approach is not going to work. But if you look at the standard headings I think you will find that they do work.
User | Count |
---|---|
125 | |
106 | |
99 | |
63 | |
62 |
User | Count |
---|---|
135 | |
116 | |
101 | |
71 | |
61 |