DAX not working in matrix, but works in table

[adi-elena]

Hello everyone,

I'm struggling with creating a matrix that sums up 4 quarters.

Each quarter, I applied a filtering function, and show up correctly per Line of business let's say, but not working for the sum of all.

If I try one account that sums all line of businesses, works in a table, but if I try to put it in my full year matrix, it doesn't pick up.

NOt even sure how to ask this, I'm just not sure what's going wrong 😞

THanks,

Adi

[v-deddai1-msft]

Hi @adi-elena ,

Would you please inform us more detailed information( your sample data(by OneDrive for Business)) if possible? Then we will help you more correctly.

Please do mask sensitive data before uploading.

Thanks for your understanding and support.

Best Regards,

Dedmon Dai

[amitchandak]

@adi-elena ,

Can you share sample data and sample output.