Using USERELATIONSHIP several times inside the same measure

[Anonymous]

Hi,

I have a table with several dates columns, and I need to create a table with counts of them.

The basic ones, which are of the form CALCULATE( COUNTA( Table[Column] ), USERELATIONSHIP( Calendar[Date], Table[Date_Col] ) I already know how to get.

What I'd like to know is whether I can use USERELATIONSHIP several times in the same measure, and specify to which part of the measure that relationship has to be applied. Something like this:

Measure = CALCULATE( COUNTA( Table[Column1] ),

     FILTER( Table, Table[Date_1] <> BLANK() ) && USERELATIONSHIP( Calendar[Date], Table[Date_1] ),

     FILTER( Table, Table[Date_2] = BLANK() ) && USERELATIONSHIP( Calendar[Date], Table[Date_2] )

)

Thanks in advance!

[v-diye-msft]

Hi @Anonymous 

If the above posts help, please kindly mark it as a answer to help others find it more quickly. thanks!

If not, please kindly elaborate more.

[amitchandak · Accepted solution]

@martifapa , Not for the same table set.

But you can try as

Measure = CALCULATE( COUNTA( Table[Column1] ),
	FILTER( Table, Table[Date_1] <> BLANK() ) , USERELATIONSHIP( Calendar[Date], Table[Date_1] ))
) 
+ 
CALCULATE( COUNTA( Table[Column1] ),  FILTER( Table, Table[Date_2] = BLANK() ), USERELATIONSHIP( Calendar[Date], Table[Date_2] ))