topic Re: How to make a measure with 3 fact columns in DAX Commands and Tips

How to make a measure with 3 fact columns

Anonymous — Thu, 05 Jan 2023 14:56:08 GMT

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:

-Ticket

-Ticket

-Operaçao

-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 — Thu, 05 Jan 2023 15:10:00 GMT

Hi Anonymous

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

Anonymous — Fri, 13 Jan 2023 14:37:17 GMT

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 — Fri, 13 Jan 2023 15:39:44 GMT

Anonymous

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