Forum Discussion

ROOY1's avatar
ROOY1
Regular Visitor
2 years ago
Solved

Matrix with Measure doesn't SUM

Hello all,   I made a Measure but i am not receiving the expected results on my martix visual in PBI.  I want for every staff member who is ZZP or Charter and drove 1 or more orders on a day a 1 a...
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi ROOY1 ,

    I created the sample data myself but both row and column subtotals work fine, unfortunately I can not reproduce your problem.

     

    I can not help you very well. Maybe you can provide me with your pbix file?

     

    Please remove sensitive data and do not log in to your account in Power BI Desktop when uploading pbix files.

     

    All this is to better solve your problems.

     

    I would be grateful if you get back to me quickly.

     

    Best Regards,
    Yang
    Community Support Team

     

    If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly.
    If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi ROOY1 ,

 

Thanks for the reply from Greg_Deckler , please allow me to provide another insight:

 

Please modify your measure syntax:

Aantal Extern Test Revised = 
SUMX(
    VALUES(RITDETAILS[DATUM]),
    VAR CurrentDate = RITDETAILS[DATUM]
    VAR CurrentStaffNum = SELECTEDVALUE(Ritdetails[StaffNumber])
    RETURN
        IF(
            CALCULATE(
                COUNTROWS(Ritdetails), 
                FILTER(
                    Ritdetails, 
                    Ritdetails[Transporteur] IN {"ZZP", "Charter"} 
                    && Ritdetails[StaffNumber] = CurrentStaffNum 
                    && Ritdetails[Datum] = CurrentDate
                )
            ) >= 1, 
            1, 
            BLANK()
        )
)

 

If it does not work after modification, please provide me with sample data, please remove any sensitive data in advance.

 

Best Regards,
Yang
Community Support Team

 

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

  • ROOY1's avatar
    ROOY1
    Regular Visitor
    2 years ago

    Hi Yang,

     

     I have tried your modification and here is the result: 

    Now column subtotals are working but row subtotals are not working yet :(.

    • Anonymous's avatar
      Anonymous
      Not applicable
      2 years ago

      Hi ROOY1 ,

      I created the sample data myself but both row and column subtotals work fine, unfortunately I can not reproduce your problem.

       

      I can not help you very well. Maybe you can provide me with your pbix file?

       

      Please remove sensitive data and do not log in to your account in Power BI Desktop when uploading pbix files.

       

      All this is to better solve your problems.

       

      I would be grateful if you get back to me quickly.

       

      Best Regards,
      Yang
      Community Support Team

       

      If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly.
      If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!