Forum Discussion
Hide blank values in matrix view
have a look at this file
https://1drv.ms/u/s!AjxUGXgGNzCEiV4mePewl33dzvil
with the way joins are set up you don't even have to specify in/out filter cause it comes from the visual fitler context
Community Championwhy not appending the two tables? they seem to have indentical structure, you already have in/out flag and you will not need the bridge anymore + the matrix should show it as one
Althoughyou are correct in this example as it doesnt make sense to split the table, however the actual production report contains indivdual measures which splits the attempt/cold/warm states based on their standard deviation values.
So I have a SDTable where it contains the measures that calculates the SD 1 and 2 for each type of call (eg Warm_In, Warm_out, Attempt_In, Attempt_Out, etc):
Then I have filter where I can select the SD value from the SDTable above.
See below I still get the same issue when using a merged table:
If this can be achieved using a merged table then of course this will be a preffered solution.
- Stachu
I'm not sure I get the complexity fully, but you could have a table like this one:
and use this code for SELECTEDVALUE to specify between In/Out
CALCULATE(SELECTEDVALUE(SDTable[Attempt]),SDTable[Direction]="In")
or you could do the Join table with SD with In/Out values only so it would always be filtered for single entry, but that may make model more complex
Yes so I have a alternative SDTable that does this;
But the resulting matrix still ends up looking like this:
How would I use a join SD table to filter the attempt_I, and attempt_O to their repective group, thus not showing any blanks?
- Stachu
have a look at this file
https://1drv.ms/u/s!AjxUGXgGNzCEiV4mePewl33dzvil
with the way joins are set up you don't even have to specify in/out filter cause it comes from the visual fitler context