Forum Discussion

dhannaa's avatar
dhannaa
Icon for Helper IV rankHelper IV
4 years ago
Solved

Dynamic conditional usage of dimension tables

Hi all, I'm trying find the best solution for filtering accounting data based on different custom groupings. I currenly have this kind of parameter table for groupings.  And thes...
Need Help
  • Anonymous's avatar
    Anonymous
    4 years ago

    Hi dhannaa ,

    Please refer to my steps to see if it helps you.

    Create relationships between the three tables.

    Then create a measure.

    balance = 
IF(SELECTEDVALUE(Table_3[Dimension])=1,"Group4",IF(SELECTEDVALUE(Table_1[Grouping])=2&&SELECTEDVALUE(Table_2[CostCenter])=1,"Group2",IF(SELECTEDVALUE(Table_1[Grouping])=3&&SELECTEDVALUE(Table_2[CostCenter])=2,"Group3","Group1")))

    If I have musunderstood your meaning, please provide your pbix without privacy information and desired output.

     

    Best Regards

    Community Support Team _ Polly

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

     

     

     

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hi dhannaa ,

Please refer to my steps to see if it helps you.

Create relationships between the three tables.

Then create a measure.

balance = 
IF(SELECTEDVALUE(Table_3[Dimension])=1,"Group4",IF(SELECTEDVALUE(Table_1[Grouping])=2&&SELECTEDVALUE(Table_2[CostCenter])=1,"Group2",IF(SELECTEDVALUE(Table_1[Grouping])=3&&SELECTEDVALUE(Table_2[CostCenter])=2,"Group3","Group1")))

If I have musunderstood your meaning, please provide your pbix without privacy information and desired output.

 

Best Regards

Community Support Team _ Polly

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.