Measure - Count two columns with certain values

Question

Hi thereI have two columns Current Month and 48hrs.&nbsp;I would like to count the rows where Current Month value = "Yes" and 48hrs value = "&lt;=48hrs"&nbsp;Example TableCurrent Month&nbsp; &nbsp;|&nbsp; 48hrsYes&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;=48hrsNo&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&gt;48hrsYes&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;=48hrs&nbsp;This should return a value of 2.&nbsp;Any help with the dax is much appreicated.Tim&nbsp;

amitchandak · Answer

Anonymous , Like
calculated(countrows(Table),filter(Table,Table[Current Month value] = "Yes" &amp;&amp; Table[48hrs value] = "&lt;=48hrs"))

anonymous · Answer

Perfect... worked a treat 🙂

Forum Discussion

Measure - Count two columns with certain values

2 Replies

Related content

Measure two columns

Measure or Calculated Column

Blank columns when doing Measure Name Measure Value approach

column vs measure

Measure not recognizing columns