Gerar relatorio com trigger

[adamfingol]

Ola tenho uma tabela de registros de falha e uma tabela de trigger por falha. Eu quero gerar uma visualização onde só apeça na lista quando o registro apareça a quantidade de vezes marcado na lista na tabela de trigger.

ao usar o comando

Medida = if((Values(Logs[Mnemonic] ) = VALUES(Th_Falhas[falha])) ; [TH] ; "False" )

quando Logs[Mnemonic] é diferente ao h_Falhas[falha] da erro.

[v-lili6-msft · Accepted solution]

hi, @adamfingol 

Sample data and expected output would help tremendously. Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

And if these two tables have created the relationship?

if you may try this measure

Medida = if((SELECTEDVALUE(Logs[Mnemonic] ) =SELECTEDVALUE(Th_Falhas[falha])) ; [TH] ; "False" )

Best Regards,

Lin

[adamfingol]

Tankyou, work perfect.

One more question, Why your comands work and my no, this is Dax or Language M?

I need study more i need tips witch i start study DAX or Language M or other?

Tankyou!

[v-lili6-msft]

hi, @adamfingol 

Values returns a table, so for two tables, it doesn't work.

For power bi, you need to study DAX or M Language first.

http://radacad.com/m-or-dax-that-is-the-question

Best Regards,

Lin

[adamfingol]

Tanks you are the best!