Forum Discussion
matrix table filtering issues
Yes, you are right. It looks like the budget source is missing some rows from actual source.
In this case - you can do following steps
1. Click on Transform data
2. Append table_a with table_b.
3. Remove Duplicates using the following option
then use Table_A in your model
I think there are some improvements needed in your model.
I don't think we need separate dimensions for Budget and Actuals. You have to connect GL Account, Broad_cat the same way you are connecting Calendar table. The only table is sufficient.
I didn't check everything but now stores values make sense
I would say its is applicable to all the dimensions which are created using _a and _b - There should be one dimension which is controlling both tables actuals and Budget
If they do not belong to same source, you can combine both dimension in power query and prepare just one table from them and connect as above
I tried changing the model as you suggested, yield the same results as you , numbers do tally now BUT
i realised that there seems to be an empty rows with values like in your second photo(first row under stores blank category , with value of 2287).
Do the rows arise because one of the sources does not have it in them? How do i deal with this empty row issue