Forum Discussion
Solved
Help with Union DAX
Hi! I'm trying to create a calculated table that consists of some static text and measures. The measures show the correct values when I put them into a card, however when I'm creating a calculate...
rbreneman Solution attached below sig. First, the reason it wasn't working is that your calculated table was not taking into account the slicer selections (row context instead of filter context because it is a table). So, the solution is essentially the disconnected table trick:
- Create a disconnected table with your values, Building, District, etc.
- Create a Measure2Show that depending upon the MAX of your disconnected table, return the appropriate measure
rbreneman Solution attached below sig. First, the reason it wasn't working is that your calculated table was not taking into account the slicer selections (row context instead of filter context because it is a table). So, the solution is essentially the disconnected table trick:
- Create a disconnected table with your values, Building, District, etc.
- Create a Measure2Show that depending upon the MAX of your disconnected table, return the appropriate measure
Greg_Deckler you are a rockstar! Thank you so much! Your solution works great, and I like it even more than having to manage a calculated table.