Forum Discussion

parkinson13's avatar
parkinson13
New Member
4 years ago
Solved

Issues with SUM Grouping

Hi, I've used PowerBI quite a bit previously but am building a new report today and I'm getting some behaviour I've not experienced before with totals.   In my table I just want to show the value ...
Need Help
  • parkinson13's avatar
    parkinson13
    4 years ago

    Appologies for the delay in coming back to you. I hadn't been able to work on this again for the last week.

     

    These measures helped for one of the cards but not the other 2 and I've been trying to work out what the difference is. I've made some queries directly in SQL to compare the row data and in SQL it matches my table in Power BI but not the card values.

     

    Seen as I had created the queries in SQL anyway and I know SQL better than I do PowerBI I just created a view with what I needed and used those in PowerBI to get what I needed for now.

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

parkinson13 , Check the three measures if they can help

 

calculate(sum(Table[Value]), filter(Table, Table[Status] =0))

 

calculate(sum(Table[Value]), filter(Table, Table[Status] =0 && Table[Type] = "Type 1"))

 

calculate(sum(Table[Value]), filter(Table, Table[Status] =0 && Table[Type] = "Type 2"))

  • parkinson13's avatar
    parkinson13
    New Member
    4 years ago

    Appologies for the delay in coming back to you. I hadn't been able to work on this again for the last week.

     

    These measures helped for one of the cards but not the other 2 and I've been trying to work out what the difference is. I've made some queries directly in SQL to compare the row data and in SQL it matches my table in Power BI but not the card values.

     

    Seen as I had created the queries in SQL anyway and I know SQL better than I do PowerBI I just created a view with what I needed and used those in PowerBI to get what I needed for now.