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

Highlighted
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ç.

Fcoatis Member
Member

Re: Evaluating 2 conditions

Olá @PGAndrade ,

 

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

 

Grande abraço

Helpful resources

Announcements
October 2019 Community Highlights

October 2019 Community Highlights

October was a busy month in the community. Read the recap article to learn about some of the events and content.

New Solution Badges

New Solution Badges

Two waves of brand new solution badges are coming! Read the article for more information on our new community badges.

Ask Amir Anything

Exclusive LIVE Community Event No. 2 – Ask Amir Anything

Next in our Triple A series: Ask Amir Netz questions about the latest updates, features and future.

Analytics in Azure virtual event

Analytics in Azure virtual event

Experience a limitless analytics service built to ingest, prep, manage, and serve data for immediate use in Power BI.

Users Online
Currently online: 424 members 4,154 guests
Please welcome our newest community members: