Forum Discussion
matrix visual - do not show total for one column
Memorable MemberSee the image below. The metric "Measure" was not calculated for Total line. How do I identify the total line? You need to understand how filter context works. On a high level each cell is calculated independently in a matrix. In the example,
for the first line, the table "Table" is filtered for date 01/01/2020 and sums the sales column for the returned rows.
for the second line, the table "Table" is filtered for date 01/05/2020 and sums the sales column for the returned rows and so on. So each row has a date filter which filters the table "Table" based on defined relationship. But the total line does not have any date filter. When the condition fails in HASONEFILTER, it just blanks out based on the measure formula.
Read this article to better understand the concept.
https://www.sqlbi.com/articles/row-context-and-filter-context-in-dax/
If it helps, mark it as a solution
Kudos are nice too.
Thank you for the through explination and the example.
If I understand correctly I need to replace my current Date of registrtion request column with the measure: