Dynamic Table with field parameter and two value slicers partially working.
Hello Everyone. I need some help to cross the finish line on a visual and was hoping it would be an easy fix with some guidance from the community. I have a matrix table visual as shown below. I want this table to update dynamicaly based on the CV and SV buttons. So far I have been able to do that. I also want it to update dynamically based on the negative and/or positive limit that the user selects in the negative and positive limit slicers. So far I have been able to accomplish this partially with the CV selection, but not the SV selection. Below example shows the CV table accurately change based on the limit slicers, but when changed to the SV view the table is still basing results off of the CV measure. Measures for columns shown as 1 on the table are shown below (IncludeValueCV, IncludeValueSV). IncludeValueCV = IF( [CV Cur] < SELECTEDVALUE('Lower Limit'[Lower Limit]) || [CV Cur] > SELECTEDVALUE('Upper Limit'[Upper Limit]), 1, 0 ) IncludeValueSV = IF( [SV Cur] < SELECTEDVALUE('Lower Limit'[Lower Limit]) || [SV Cur] > SELECTEDVALUE('Upper Limit'[Upper Limit]), 1, 0 ) Here are is the parameter and values that are in the matrix table. prm_variance_options = { ("CV", NAMEOF('fct_ev_data'[CV]), 0, "CV"), ("1", NAMEOF('fct_ev_data'[IncludeValueCV]), 1, "CV"), ("SV", NAMEOF('fct_ev_data'[SV **bleep** EOM]), 0, "SV"), ("1", NAMEOF('fct_ev_data'[IncludeValueSV]), 1, "SV") Here are the parameters for the lower and upper limit slicers. Lower Limit = GENERATESERIES(-5000000, 0, 50000) Lower Limit Value = SELECTEDVALUE('Lower Limit'[Lower Limit]) Upper Limit = GENERATESERIES(0, 5000000, 50000) Upper Limit Value = SELECTEDVALUE('Upper Limit'[Upper Limit]) I appreciate any guidance the community can provide in getting both CV and SV values in the matrix table when updating the lower and upper limit value slicers. Thank you. Joaquin C.
