Forum Discussion
USERELATIONSHIP
Hi reiskleiton ,
Looking at the data you have given beliw you can do it adding the following measure:
Excesso de limite = CALCULATE(SUM(CAR[Montante]); CAR[Cliente] in VALUES('Ordem Bloq'[Cliente]))Check result in attach PBIX.
Hi reiskleiton ,
This has to do with context, so you need to do one of two thing, or to add the cliente to your visualization or make the SUMX based on the Cliente.
can you share a mockup of your data?
Hi MFelix
I tried to explain how it should work.
It could be done in Power Query by Merge (Right Outer) CAR[Cliente] = Ordem Bloq[Cliente] AND Calendário [Mês e Ano], but I want to avoid to create a unecessary table to my model.
Thank you for your help.
Hi reiskleiton ,
Can you please explain how the calculation for the last column is done.
If I look I have the following data:
April - 3 customers in CAR with a total of 300 but only 1 cliente in Bloqueado on that date with the value of 200.
June - 3 customers in CAR with a total of 300 but 5 cliente in Bloqueado on that date with the value of 1000. your total value is 100
Can you give a little bit more detail please.
Hi MFelix
Sorry, I made a mistake.
You got it right.
April - 100 (1 cliente from CAR)May - 200 (2 clientes from CAR)
June - 300 (3 clientes from CAR)
Please, remember that the Excesso Limite is SUMX(
FILTER(CAR;CAR[Cliente] =Ordem Bloq[Cliente]);
CAR[Montante]
)
Do you need more information?
Thank you.
