Filtering the report

[GuestUser]

Hi,

Reports are connnected to SSAS (Tabular Model) - Connect Live

I have 2 measures

Department count of emp , attrition count
abc                     5                        4
xyz                      0                        2
pqr                     4                         0
aaa                    0                           0

I do not need last row which has both 0 .. I am not put a filter condition since it removes (xyz or pqr also)

Any suggestion pls

[Greg_Deckler · Accepted solution]

Create a third measure:

Measure = IF([count of emp] = 0 && [attrition count] = 0,0,1)

Filter on that.