matrix table filtering issues

[Anonymous]

Hi all , 

I have two issues regarding my dashboard, attached some photos and a link of sample dashboard

Here are my issues

1) Why does the matrix table sub rows not filter according to the center table in figure 1

(fig1)

I would like the sub rows to be filtered similar to the below table(fig2)

Why does the matrix table sub rows not filter according to the center table in figure 1

(fig2)

2) Why does the budget values expansion of sub rows not tally to the values when i collapse the expansion---> please see attached link for the visual

https://drive.google.com/file/d/1_njm36eCdTax1YvKYD0aanJ35Q8X0AG_/view?usp=sharing

highlighted expansion does not tally up to 36,509

Thanks for help

[sayaliredij · Accepted solution]

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

[sayaliredij]

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

[Anonymous]

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