Ignore/remove blanks from this calculated table

[AndreT]

Hi,

This have came up in some post I saw, but the ignore funciton didn't work for me.

Any idea how to elimante blanks from below?

[v-ljerr-msft · Accepted solution]

Hi @AndreT,

If I understand you correctly, the formula below should work in your scenario. 

test =
FILTER (
    ADDCOLUMNS (
        SUMMARIZECOLUMNS ( 'Committment Table'[Week] ),
        "Total Commitment", 'Committment Table'[commitment % companies]
    ),
    [Week] <> BLANK ()
)

Regards