Count multiple rows for duplicate including blanks

Question

Hi,First of all apologies if this is a duplicate request, I am trying to create a measure that will count multiple columns, if any of the rows are blank then it would return 0.&nbsp; The columns are ID number, start date, start time - if any of these are blank then I would need it to return 0, also if any of the rows in all 3 column are all the same I need it count the number of entries it appears in the entire dataset.Please see table below, the 4th column named results is what I want my measure to return.&nbsp;ID&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Start Date&nbsp; &nbsp; &nbsp; Start Time&nbsp; &nbsp;Results1234&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;0&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 11/01/2021&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;15:30&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;09876&nbsp; &nbsp; 11/01/2021&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 09:05&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 19876&nbsp; &nbsp; 13/01/2021&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;13:45&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;13456&nbsp; &nbsp; 01/02/2021&nbsp; &nbsp; &nbsp; &nbsp; 19:30&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 23456&nbsp; &nbsp; 01/02/2021&nbsp; &nbsp; &nbsp; &nbsp; 19:30&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 26789&nbsp; &nbsp; 16/01/2021&nbsp; &nbsp; &nbsp; &nbsp; 19:30&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 36789&nbsp; &nbsp; 16/01/2021&nbsp; &nbsp; &nbsp; &nbsp;19:30&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;36789&nbsp; &nbsp; 16/01/2021&nbsp; &nbsp; &nbsp; &nbsp;19:30&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;3&nbsp;&nbsp;

jihwan_kim · Accepted Answer

Hi,&nbsp;pardeepd84&nbsp;&nbsp;Please try the below measure.&nbsp;Result =VAR currentid =MAX ( 'Table'[ID] )VAR currentdate =MAX ( 'Table'[Start Date] )VAR currenttime =MAX ( 'Table'[Start Time] )VAR newtable =FILTER (ALL ( 'Table' ),'Table'[ID] &lt;&gt; BLANK ()&amp;&amp; 'Table'[Start Date] &lt;&gt; BLANK ()&amp;&amp; 'Table'[Start Time] &lt;&gt; BLANK ()&amp;&amp; 'Table'[ID] = currentid&amp;&amp; 'Table'[Start Date] = currentdate&amp;&amp; 'Table'[Start Time] = currenttime)RETURNCOALESCE ( COUNTROWS ( newtable ), 0 )&nbsp;Hi, My name is Jihwan Kim. If this post helps, then please consider accept it as the solution to help other members find it faster.

Forum Discussion

Count multiple rows for duplicate including blanks

2 Replies

Related content

How to include multiple columns in Activator

PowerBI Desktop - duplicate a table including all DAX

Duplicate ranking

remove duplicate value within a row

Remove duplicates based on multiple columns