Forum Discussion
How to force a slicer from a table without Data using DAX?
if the table in your post is correct, I suspect this is part of your issue.
The other issue you'll have is that since their is no id in Table A to link to in Table B the values in table B will show as a blank territory. you say you have to slice on Table A territory, but is there really no way to use an intermediate dimension table? I got a sample to work, using a dimension table related to A and B instead of relating A to B.
This should force it to show up by giving it a value. however this will show all values to show up so you might need an additional filter on the x-axis to only show what you want to see
Measure Actuals Continuous =
IF(
ISBLANK([Measure Actuals]),
0,
[Measure Actuals]
)
Thank you for your resopnse Anonymous. So I did try this and March does come out as a 0 for Actuals on the x axis. The problem is that the budget shows as a blank as opposed to 5000. Ideally, what I need is for March Actual to show the 0 with the IF expression you have suggested and March Budget shows 5000.
if the table in your post is correct, I suspect this is part of your issue.
The other issue you'll have is that since their is no id in Table A to link to in Table B the values in table B will show as a blank territory. you say you have to slice on Table A territory, but is there really no way to use an intermediate dimension table? I got a sample to work, using a dimension table related to A and B instead of relating A to B.
I typed the sample tables manually, thus the error you are highlighting. Great catch! In my model the ID column is built with a nested CONCATENATE expresion so it is right.
I think it does have more to do with the Territory I'm using to slice the matrix/visual not existing due to no Actuals being recorded in March. I'll go ahead and create an intermidiate dimension table, hopefully this will solve the problem!
Thanks again!