Forum Discussion
switching slicer context based on calculated column logic
Sorry fo the late reply, and thanks. I think I understand your binning suggestions. Though, not quite solving. For sure, instead of using the calculated column (which i did initially for the binning), I can just use a measure to dynamincally determine the status for each aggregate 'company' value. However, I can't get my head around getting the correct sum value for these status bins in a separate table. I'm not sure if my logic can create bins the same way you discribe within a parameter slicer. Though, ulitmately, my goal is to get the correct total for the aggregate total of increases/decreases in a visual and use a parameter slicer to filter the larger company table... (TBH, i'm not sure if that is possible based on my data)
Ultimately, the poroblem is that there are mulitple row contexts for each company, I want a table count and slicer to ignore the row context and provide a count for each company based on overall status (dictated by my meaaure). I don't want the count for each row instance of an increase or decreased of that same company.
example below....this is the Dynamic measure table view that gives me correct aggregate values. It states the correct overall context of the companies. that's good. The question is, how do I ignore the row context, and show the correct aggregate status values outside of this table view?
Can i dynamincally create a table like this that ignores row context of my data? can i slice other visuals by these categories?
6 companies, and their aggregate status breakdown is this:
------
2 - decrease
1 - increase
1 - no funding change
2 - 0 both years
-----
------raw data