Forum Discussion
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
Total Sold - quantity of cabins sold
When using a simple Table visual it shows the correct Total Qty available which is max of 9. But when i use the Matrix as a visual it seems to show a different total available rooms for certain dates. The total rooms cannot be more than 9.
Just FYI Ive created three measures as below to be able to show items with no data. For e.g.
Hi mohsenask ,
However, I didn't see the error you described in the matrix visual based on your attached .pbix file.
Best Regards,
Yuna
7 Replies
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.
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
 
amitchandak - any help???
Ive attached a test pbix file - https://www.dropbox.com/s/59c5luuqbby2wxg/BG_MIS_test.pbix?dl=0
Hi mohsenask ,
However, I didn't see the error you described in the matrix visual based on your attached .pbix file.
Best Regards,
Yuna
Hi mohsenask ,
If your problem has been solved, Could you kindly Accept it as the solution? 😉
Best Regards,
Yuna
