Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
1 year ago
Solved

User selectable values from dim table

Hello, I am implementing a new feature on a report page which allows a user to select which list of values from dim_table01 will then be used to filter three fact tables. The goal here is for the us...
Need Help
  • Anonymous's avatar
    Anonymous
    1 year ago

    Hi Anonymous ,

     

    I made a sample for you.

     

    Measure = SWITCH(
    SELECTEDVALUE('dim_type'[type]),
    "sel_01",
    IF( VALUES( 'dim_table01'[col-01])=TRUE(),CALCULATE( SUM('fact_table01'[value]),USERELATIONSHIP(dim_table01[col-00],fact_table01[fact_c01])),BLANK()),
    "sel_02",
    IF( VALUES( 'dim_table01'[col-02])=TRUE(),CALCULATE( SUM('fact_table02'[value]),USERELATIONSHIP(dim_table01[col-00],fact_table02[fact_c01])),BLANK()),
    "sel_all",
    IF( VALUES( 'dim_table01'[col-all])=TRUE(),CALCULATE( SUM('fact_table03'[value]),USERELATIONSHIP(dim_table01[col-00],fact_table03[fact_c01])),BLANK())
)

     

    Best Regards,

    Wearsky

lbendlin's avatar
lbendlin
Icon for Super User rankSuper User
1 year ago

Are you trying to reinvent the Field Parameters feature?

  • Anonymous's avatar
    Anonymous
    Not applicable
    1 year ago

    I have tried Filed Parameters (FPs). I created a FP which inlcluded col-01, col-02 and col-all. I found the  FP would switch between the columns however, switching the column is not enough to filter  dim_table01 and there by filter the fact_tables.
    I tried replacing the true/false values in the col-01,col-02 & col-all with values from col-00.  True = col-00 valus; False = blank.

    • lbendlin's avatar
      lbendlin
      Icon for Super User rankSuper User
      1 year ago

      How about enabling "Personalize Visuals"  and train your users in how to use that?

      • Anonymous's avatar
        Anonymous
        Not applicable
        1 year ago

        thank you for the suggestion, however, I do not see that as an option right now.