Differences between Table and Matrix Visualization

[admin_xlsior]

Hi guys,

What is the differences between Table Visual and Matrix Visual, besides Matrix are able to put data column wise like pivot table ?

If without sample of the data or take a look at the measure, can someone advise why with the same data, I have 2 different result, as below :

As in above pict, the value (last column) is only in row October 2015 - External and November 2015 - external. 

But when I changed (instantly) to Matrix visualization, suddenly I have value for August 2015 and September 2015 while November 2015 is missing :

The value itself is a measure.

Is with the same data and measure, Table Visualization and Matrix possible to have this kind of behaviour ?

Thanks,

[parry2k]

@admin_xlsior Can you share measure expression? this seems really odd. if you can share sample data with relationship diagram, will help to investigate it further.

[admin_xlsior · Accepted solution]

Hi thanks for your kind reply.

I resolved this however, but just for information, this is the website I try to use before. It is realy great blog, btw.

https://blog.gbrueckl.at/2014/12/events-in-progress-for-time-periods-in-dax/

.. and my error is resolved because it realy needs a free no-relationship Date dimension to use. I just create new Date dimension and  problem solved.