How to make a measure with 3 fact columns

[Anonymous]

Hi,

I need to make a measure with 3 fact columns.

The similar dates in this 3 columns is the column  Ticket.

The dates i would like to use are:

• Fact1:

-Ticket

• Fact2:

-Ticket

-Operaçao

• Fact3:

-Ticket

-n-doc

I've tried to made this measure for apply in my table  and one graph but this doesn't worked:

VAR OP = IF([Soma-Tickets-operacao] = [Soma_tickets],[soma-operacao-ticket-operaçao], BLANK())

VAR OP2 = IF([soma-zmm044-tickets] = [Soma_tickets],[Soma-n-documento], BLANK())

VAR OP3 = IF(OP = BLANK() && OP2 = BLANK(), 1, 0 )

return

OP3

[tamerj1]

Hi @Anonymous 

please share some screenshots and advise the dax for the three measures 

[Anonymous]

To =

VAR OP = IF([Soma-Tickets-operacao] = [Soma_tickets],[soma-operacao-ticket-operaçao], BLANK())

VAR OP2 = IF([soma-zmm044-tickets] = [Soma_tickets],[Soma-n-documento], BLANK())

VAR OP3 = IF(OP = BLANK() && OP2 = BLANK(), 1, 0 )

return

OP3

[tamerj1]

@Anonymous 

Please try by switching the relationships between 'f_ticket_balanka' and both 'f_2' and 'f_t3' to both way instead of single.