Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi, read a few posts on this but can't find exactly what I need. I'm creating a measure which will be used in another calculation. The inital measure I am creating needs to be filtered based on values in other tables.
Below is my measure working with a couple of filters
Solved! Go to Solution.
Hi @sanderson82 ,
In your scenario, we can use the RELATED() funtion and && to write the DAX query:
TotalTransport = CALCULATE( SUM(PCProjectEntry[GoodsAmountInBaseCurrency]), FILTER(PCProjectEntryDescriptor,PCProjectEntryDescriptor[Name]="Purchase Invoice"), FILTER(PCProjectItem,PCProjectItem[Code]="Transport" && RELATED(PCProjectEntryDescriptor[Name])="Purchase Invoice")
Best Regards,
Teige
Hi @sanderson82 ,
In your scenario, we can use the RELATED() funtion and && to write the DAX query:
TotalTransport = CALCULATE( SUM(PCProjectEntry[GoodsAmountInBaseCurrency]), FILTER(PCProjectEntryDescriptor,PCProjectEntryDescriptor[Name]="Purchase Invoice"), FILTER(PCProjectItem,PCProjectItem[Code]="Transport" && RELATED(PCProjectEntryDescriptor[Name])="Purchase Invoice")
Best Regards,
Teige
User | Count |
---|---|
93 | |
85 | |
78 | |
68 | |
62 |
User | Count |
---|---|
113 | |
99 | |
96 | |
64 | |
58 |