Forum Discussion
Parameter controlled visual and filtering the tooltip
Can you please share the measures you are using, and confirm that in the tooltip you are using the Qarter from the disconnected table
sure MFelix
TT Total CERs =
CALCULATE(COUNT('CER Info'[CER_REQUEST_SEQ]),
not ('CER Info'[CER Status] in {"Rejected", "Withdrawn"}) ,
REMOVEFILTERS('CER Info'[Active-Completed]), REMOVEFILTERS('CER Info'[ACSort]), REMOVEFILTERS(Dates[Quarter]), REMOVEFILTERS(Dates[Year Quarter Number]),
Treatas ( Values('Qtr Table'[Quarter]),Dates[Quarter])TT Total CERs3 =
// This count excludes Rejected and Withdrawn CERs
CALCULATE(COUNT('CER Info'[CER_REQUEST_SEQ]),
not ('CER Info'[CER Status] in {"Rejected", "Withdrawn"}) ,
REMOVEFILTERS('CER Info'[Active-Completed]), REMOVEFILTERS('CER Info'[ACSort]), REMOVEFILTERS(Dates[Quarter]), REMOVEFILTERS(Dates[Year Quarter Number]),
REMOVEFILTERS('Qtr Table'[Quarter]), 'Qtr Table'[Quarter] = SELECTEDVALUE('Qtr Table'[Quarter])
)TT Completed3 =
// This count includes only incluedes those that are "Completed" by Completion Timing. It excludes those that are completed by NOT linked.
Calculate (
[Count On Time] + [Count Completed (CompTiming)] + [Count Late] ,
REMOVEFILTERS('CER Info'[Active-Completed]), REMOVEFILTERS('CER Info'[ACSort]), REMOVEFILTERS(Dates[Quarter]), REMOVEFILTERS(Dates[Year Quarter Number]),
REMOVEFILTERS('Qtr Table'[Quarter]), 'Qtr Table'[Quarter] = SELECTEDVALUE('Dates'[Quarter])
)
Year is from my Dates table (which I'm pretty sure is already shared in this thread somewhere), Quarter is from your suggestion of using a disconnected table with just Quarter.
Hi jjustjjo
One adicional question what os your original measure that you are using on the visual.
Asking this because it seems like you have added my code to your measure and the idea is to overcome the filter context that is coming from the visual.
In that case you must do a CALCULATE of the original measure and not add the additonal syntax that I have provided.
If you see my code I have CALCULATE then I call my measure Total Sales and the filter is the remove filters.
MFelix I appreciate your help very very much. I'm just over trying to get this to work after over a week fighting it, trying multiple suggestions, adding filters, removing filters, adding disconnected tables, adding more disconnected tables. Had I been able to post a simple pbix with my exact setup, this would have been solved in a day. I'm not the best at sharepoint and links, and I'm pretty sure my company won't allow me to post a company sharepoint link here.
I've had to move on to converting other reports from Tableau because I'm under a time-crunch deadline before they take that away. I will keep the email notification of your reply in my inbox should I have time to get back to it. Until then, I'm just going to tell my users I can't give you what you had before.Hi jjustjjo ,
If you need anything just let me know, but if you allow me you must try and understand the filter context otherwise the transition from tableau will be very difficult saying this from experience on migrating reports from sevral different bi tools to Power BI and the way dax is structured is very different from others (will not go to the discusssion if is better or worst).
Again if you need help just let me know if you want we can have a small call and probably this can be solved. Just send me a pm.
MFelix Yes, I am aware of filter context. I have the Ferrari/Russo book on my desk. I was solving something else when I stumbled across the whole "hidden filter" bit if you sort by another column. The closest I've gotten to solving this is to at least have all the values show up in my actual tooltip, but I can't get it to show for all quarters when hovering over the view by quarter; or when it does show all quarters, it shows the same value for each quarter. View by year works. Anyway, I do appreciate your help and will reach out again if I get back to this.