Forum Discussion

GuestUser's avatar
GuestUser
Helper V
6 years ago
Solved

Filtering the report

Hi,   Reports are connnected to SSAS (Tabular Model) - Connect Live I have 2 measures Department count of emp , attrition count abc                     5                        4 xyz         ...
Need Help
  • Greg_Deckler's avatar
    Greg_Deckler
    6 years ago

    Create a third measure:

     

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

     

    Filter on that.

Greg_Deckler's avatar
Greg_Deckler
Community Champion
6 years ago

Create a third measure:

 

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

 

Filter on that.