Card visual shows correct value but matrix visual returns nothing

[Ackbar-Learner]

Hi there

I created a measure to sum all transactions removing all filters first and then applying my necessary filters. Measure is below

BSNetProfit = CALCULATE(sum(GLTransClient[Amount]),All(BSGLCoAHeaders[Count.Level0]),all('Calendar'[Date]),DATESBETWEEN('Calendar'[Date],[BSFirstDate],[BSDateSelected]),GLCoAHeaders[Count.Level0]="P&L")

As you can see above, the card visual shows the correct information but same is not reflected in the matrix visual. Now i tried to change the above formula to BSNetProfit = 100000 just to check if it appears and surprisingly it appears on both visual correctly.

I cannot see what is causing the issue in the first screenshot. I tried removing all filters on the matrix visual/page and it is still the same.

Any help is much appreciated.

Ackbar

[amitchandak]

@Ackbar-Learner , Try one of the two

BSNetProfit = CALCULATE(sum(GLTransClient[Amount]),All(BSGLCoAHeaders[Count.Level0]),DATESBETWEEN('Calendar'[Date],[BSFirstDate],[BSDateSelected]),GLCoAHeaders[Count.Level0]="P&L")

BSNetProfit = CALCULATE(sum(GLTransClient[Amount]),DATESBETWEEN('Calendar'[Date],[BSFirstDate],[BSDateSelected]),Filter(GLCoAHeaders, GLCoAHeaders[Count.Level0]="P&L"))

If this does not help
Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.

[Ackbar-Learner]

@amitchandak hi both of them did not work. I am going to figure out a way to share sample data with you as the file contains sensitive information as there are so many things related.

[Ackbar-Learner]

@amitchandak Hi i sent you the sample file in a private message. Please check it. You can post your reply here but please don't post the file.

Thanks Ackbar

[Ackbar-Learner · Accepted solution]

Hi solution found! I had to use crossfilter to remove existing relationships between tables. But now this is causing another issue on subtotals which I am going to post in another.