Forum Discussion
reiskleiton
5 years agoHelper II
USERELATIONSHIP
Hi all, I have tried to get data from one table based on another by using USERELATIONSHIP function. I need to get all the data that matches from CAR and Ordens Bloq tables on columns [Mês e ...
- 5 years ago
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.
MFelix
5 years agoSuper User
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.
reiskleiton
5 years agoHelper II