Forum Discussion
mohsenask
5 years agoHelper II
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...
- Anonymous5 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
mohsenask
5 years agoHelper II
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
ā
mohsenask
5 years agoHelper II
amitchandak - any help???
Ive attached a test pbix file - https://www.dropbox.com/s/59c5luuqbby2wxg/BG_MIS_test.pbix?dl=0