Forum Discussion
Filter and summarize function
Link:
https://1drv.ms/u/s!AiHR2qZdQykFgUMVU8Ct_SEqIn_E?e=PrfHoj
Background:
have three tables in the .pbix file.
1. Vehicle Parts 2. Care Mileage Date and 3.PPE ORG.
First I created a sub table called Expense- Table. It is referenced to Vehicle Parts data. For this table, I want to
1. filter the variable – ACCOUNT_NAME by Vehicle Parts – Warehouse.
2. group by variables – TRANS DATE, ORG, ORG NAME and
3. sum TRANS VALUE.
Then from PPE ORG I bring in the Org variable in the Car Mileage Data. I do this by adding a column in Car Mileage Data.
I tried to link the two table by Date and Org - Many to Many Relationship but this did not work.
Expected Result:
The result I want from the two table I.E., Expense Table and Car Mileage Data
Trans_ Date | ORG | ORG_NAME | TRANS VALUE | METER_1_USAGE | CLASS_CLASS_MAINT |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
I hope this helps. Thanks again!
For the first part you don't need DAX
To link the two tables you would use a composite key (date + org) but your car_mileage table is not clean/not covering.
Neither your Expense_table nor your PPE Org table are required.