Filtering the report

Question

Hi,&nbsp;Reports are connnected to SSAS (Tabular Model) - Connect LiveI have 2 measuresDepartment count of emp , attrition countabc&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;5&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 4xyz&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 0&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 2pqr&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;4&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;0aaa&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 0&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;0&nbsp;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 Answer

Create a third measure:
&nbsp;
Measure = IF([count of emp] = 0 &amp;&amp; [attrition count] = 0,0,1)
&nbsp;
Filter on that.

Forum Discussion

Filtering the report

1 Reply

Related content

Filtering Table report

Filters on published report

Filter

odata Report Level Filters Multiple Filters Same Column

Publish Report