Forum Discussion
columns which doesnt have data should not show in matrix table
Hi Anonymous
It's impossible to achieve that with DAX. But you may get it in Query Editor.Filter the value1 table in query editor as above mentioned.Then group the two tables to get summarized Amt columns.Then merge the two tables for Value1 table.Attached sample file for your reference.
Regards,
I have filtered the blanks in query eidter, but still it showig in the matrix table as blank column. it didnt work.
Is this something we can do using DAX? even i tried some DAX no luck.. please assist.
Apply 'is not blank' in Visual Level Filters
Anonymous wrote:
Anonymous wrote:I have filtered the blanks in query eidter, but still it showig in the matrix table as blank column. it didnt work.
Is this something we can do using DAX? even i tried some DAX no luck.. please assist.
I have filtered the blanks in query eidter, but still it showig in the matrix table as blank column. it didnt work.
Is this something we can do using DAX? even i tried some DAX no luck.. please assist.
Hi ,
it didnt work becuase values will be available for 'Amt 2' column for that month,so it will show 'Amt 1' as blanks.
so we need to ignore that month from the table itself if 'Amt 1' values are not there.
v-cherch-msftMicrosoft Employee
Hi Anonymous
It's impossible to achieve that with DAX. But you may get it in Query Editor.Filter the value1 table in query editor as above mentioned.Then group the two tables to get summarized Amt columns.Then merge the two tables for Value1 table.Attached sample file for your reference.
Regards,