Forum Discussion

Ackbar-Learner's avatar
Ackbar-Learner
Icon for Resolver I rankResolver I
4 years ago
Solved

Card 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   BSNetProfit = CALCULATE(sum(GLTransClient[Amount]),Al...
Need Help
  • Ackbar-Learner's avatar
    Ackbar-Learner
    4 years ago

    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.

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
4 years ago

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's avatar
    Ackbar-Learner
    Icon for Resolver I rankResolver I
    4 years ago

    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's avatar
      Ackbar-Learner
      Icon for Resolver I rankResolver I
      4 years ago

      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's avatar
        Ackbar-Learner
        Icon for Resolver I rankResolver I
        4 years ago

        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.