Best way to avoid blank groups in tables and matrices.

[ovonel]

I have written the below code for many different measures:

Measure :=
CALCULATE (
    SUM ( Revenue[xyz] ),
    FILTER ( 'Cost center', NOT 'Cost Center'[Department] IN { BLANK () } )
)

Initially I did it just for one; but ended up doing it for most of Revenue columns...

I did this in order to avoid the annoying first group that is blank...

Is this a correct way of fixing the blanks? or is there a more performant way?

(I work with SSAS cubes, and I would rather avoid having this fix in the .pbix)

[Anonymous]

Why not filter in the Table or Matrix using Filter Pane? ex: Department is not blank. But then you will have to do this for every Table or Matrix.

Question is why do you have Blank Department or any other Blank columns (in same hierarchy) in the Cost center dimension. Do you have correct relationships with Fact?

[Mohammad_Refaei]

before addressing the technical DAX issue, don't you have any values with blank (or null) Cost Centers?