cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Fcoatis Member
Member

Evaluating 2 conditions

Hello everyone,

I need some help Here  where I try to explain the scenario in a Word doc as well as a sample pbix file attached. If you please help.

6 REPLIES 6
PGAndrade Frequent Visitor
Frequent Visitor

Re: Evaluating 2 conditions

Hello @Fcoatis ,
As I can see you are from Brazil as weel, é nozes, jokes aside, I've made some changes to the "ult 2 Rodadas" measure, here's the file, check if this is the solution you're looking for:
https://1drv.ms/u/s!Aj9NbSmhynhdjU_GD2d-eSdeMYBB?e=RpIkVg

Fcoatis Member
Member

Re: Evaluating 2 conditions

Thank you, mermão, but you´ve got it wrong. I have ultRodadas working alone. The problem is that I have to test it in measure "Apto" in an OR clause. 

 

Fig5.PNGFig 6.PNGFig 3.PNG

PGAndrade Frequent Visitor
Frequent Visitor

Re: Evaluating 2 conditions

Ohh sorry, then this is what you wanted?
APTO.pngAPTOM.png

Fcoatis Member
Member

Re: Evaluating 2 conditions

Obrigado @PGAndrade ,

 

Na verdade não entendo porque na guia dois o visual matriz não esta funcionando. A regra é clara! para todos os arbitros disponiveis por partida a medida "Apto" precisa trazer falso ou verdadeiro baseado nas condições:

 

1. O arbitro não pode ter parcipado das duas uíltimas rodadas. ( Rodadas 12 e 13)

2. A UF do arbitro não pode ser igual a UF dos times participantes da Rodada.

 

Mas de qualquer forma obrigado pelo seu tempo.

Um abs

PGAndrade Frequent Visitor
Frequent Visitor

Re: Evaluating 2 conditions

Por nada @Fcoatis 
Mas seria esse visual que não está funcionando?
VISUAL.png
Caso consiga uma solução da um alô, tenha uma boa noite.
Abç.

Highlighted
Fcoatis Member
Member

Re: Evaluating 2 conditions

Olá @PGAndrade ,

 

Aqui está a solução sugerida pelo Leonardo Karpinski.

 

Grande abraço

Helpful resources

Announcements
Meet the 2020 Season 1 Power BI Super Users!

Meet the 2020 Season 1 Power BI Super Users!

It’s the start of a new Super User season! Learn all about the new Super Users and brand-new tiered recognition system.

Super User Challenge: Can You Solve These?

Super User Challenge: Can You Solve These?

We're celebrating the start of the New Super User season with our first ever Super User 'Can You Solve These?' challenge.

Power BI Desktop Update - February 2020

Power BI Desktop Update - February 2020

We are super excited for our update this month, as we are releasing two of our top community requests!

Power Platform Online Conference

Power Platform Online Conference

Join us for the first ever Power Platform Online Conference!

Top Solution Authors