Forum Discussion

mohsenask's avatar
mohsenask
Helper II
5 years ago
Solved

Matrix row shows different values to table

Hi   Im struggling to figure out this problem. Ive worked with Matrix before but this is driving me crazy. I have a table with following columns Date Total Qty - quantity of cabins available Tot...
Need Help
  • Anonymous's avatar
    Anonymous
    5 years ago

    Hi mohsenask ,

     

    However, I didn't see the error you described in the matrix visual based on your attached .pbix file.

     

    Best Regards,

    Yuna

     

amitchandak's avatar
amitchandak
Super User
5 years ago

mohsenask , Try this

MS_Actual_TotalQty =
IF (
isblank(CALCULATE ( SUM ( usp_GetAllocationsalesDetails_PI[TotalQty] ) )),
0,
CALCULATE ( SUM ( usp_GetAllocationsalesDetails_PI[TotalQty] ) )
)

 

or

 

SUM ( usp_GetAllocationsalesDetails_PI[TotalQty] )+0

 

Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.

  • mohsenask's avatar
    mohsenask
    Helper II
    5 years ago

     

    amitchandak - Thanks for your reply

     

    Sorry tried to paste the table here but it gives me some weird HTML error. IT says removed the invalid HTML and try submitting again but doesnt work.

    Tried uploading csv or xls - didnt allow.

     

    The below extract from the data table shows totalQty as max 9

    in a simple table visual the rows show correct TotalQty as 9

     

     

    However in the matrix its shows TotalQty as 16 for certain dates