Exclude rows in Matrix

[Henrik_99]

hi

I have the following scenario:

Matrix is not calculating the total, I'm able to create measures to count total that gives the total by Year week with SUMX;

= sumx(values(table1[discipline]),  [measure switch]

However, how can I exclude a particular row "Open comments" in total. 

"Open comments with numbers" shall remain in Matrix.

Thanks

Henrik

[Fowmy]

@Henrik_99 

You can try this modified measure:

New Measurre = 
IF( 
    SELECTEDVALUE(table1[discipline]) <> "Open comments",
    sumx(values(table1[discipline]),  [measure switch])
)

[Henrik_99]

Hi

See figure below, it doesnt  sum correctly and Open comments value disappear.

Rgds Henrik

[Fowmy · Accepted solution]

@Henrik_99 

Please try the following formula. If you want to see only the Row for Open Comments with no data, right-click on the field and choose "Show item with no data"

New Measurre = 
sumx(
    Filter(
           values(table1[discipline]),
           table1[discipline]<> "Open comments"
    ),
    [measure switch]
)