Forum Discussion
Resolver ICard visual shows correct value but matrix visual returns nothing
Hi there
I created a measure to sum all transactions removing all filters first and then applying my necessary filters. Measure is below
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
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.
4 Replies
- amitchandak
Super User
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-Learneramitchandak 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
