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 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.
Hi reiskleiton ,
Sorry for asking again, but can you break out the calcultion you are using? I understand the DAX code you place in but how is the result if you do it on a piece of paper?
What are the values you are considering for getting those values.
Hi MFelix
Please, feel free to ask many questions you want.
Let me try do explain how I would do it by Power Query.
Here are the tables used
- CAR - Group by [Mês e Ano] and [Cliente] and SUM [Montante]
- Ordens Bloq - Group by [Mês e Ano] and [Cliente] and SUM [Valor da Ordem]
- Add both to the visualization table
- Then Merge (Right Outer) CAR with Ordem Bloq
CAR[Cliente] = Ordem Bloq[Cliente]
CAR[Mês e Ano] = Ordem Bloq[Mês e Ano] - After the Merge, I will keep all the Non Blank values from CAR[Montante] and add it to the visualization.
Hope it helps you.
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.
- CAR - Group by [Mês e Ano] and [Cliente] and SUM [Montante]