Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
1 year ago
Solved

DAX formula

Hi, I have a slicer that uses this:  StandardizedName = SWITCH(     TRUE(),     'Connection Table'[Name] = "Tomatoes production", "Tomatoes",     'Connection Table'[Name] = "Cucumbers produc...
Need Help
  • Anonymous's avatar
    Anonymous
    1 year ago

    Hi Anonymous ,

     

    If you have a clear relationship between Connection Table and Production orders. You can directly put the second field into the slicer. For example, when the two fields are in the slicer, it appears the hierarchy.

     

    If the method like the one above doesn't work, then I guess you should create a table that contains your Test(fruit) column and Material.Material 01 column, and then act as a slicer.

    You'll need to create measures as filters to implement filtering for this slicer. Or you can use this new table to create relationships with other tables for filtering.

     

     

    Best Regards,

    Stephen Tao

     

    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
1 year ago

Hi Anonymous ,

 

If you have a clear relationship between Connection Table and Production orders. You can directly put the second field into the slicer. For example, when the two fields are in the slicer, it appears the hierarchy.

 

If the method like the one above doesn't work, then I guess you should create a table that contains your Test(fruit) column and Material.Material 01 column, and then act as a slicer.

You'll need to create measures as filters to implement filtering for this slicer. Or you can use this new table to create relationships with other tables for filtering.

 

 

Best Regards,

Stephen Tao

 

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
1 year ago

Thanks for your help. I do not have a clear relationship, so I will try to create a "bridge" table.