Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreGet certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now
Dears,
I would like to calculate the MTD Amount of a brand based on different categories they can reach over 5 categories in some cases.
I tried to use this but got figures from other categories not included in the measure so what is the best Dax I can use or write to fetch the data?
I really appreciate any help you can provide.
Solved! Go to Solution.
Hi,
First, I would have a filter for each field just one Filter function and as the filter fields come from one table, you can combine them into same filter function:
Did I answer your question? Then please mark my post as the solution.
If I helped you, click on the Thumbs Up to give Kudos.
Yes I tried and it works with me
Thank you too much
I would thank you too much for your reply,
I tried but it still fetches data from other categories.
the snapshot below shows the relationship between the tables
I think I have to use a category from the "oil bridge equipment table" not from the same table!
Nop, filter direction can be the problem between oil type and component. Make the relationship to filter both. It should be type filtering component, but somehow you seem to have multiple types per component. Maybe duplicates or data quality issues?
About using TotalMTD I found figures in the new month although there is no quantity issued yet, and I don't know how that happened, so I used month() instead of it.
yes I have multiple types per component I can share with you the file if you would to take a look.
https://drive.google.com/drive/folders/1Ev2mfRdHV615--SxQWBuypfL96BTdHm2?usp=drive_link
Hi,
I requested access to the google drive folder. You should have received an email.
Access is granted.
Sorry for the late.
Hi Mohamed,
The reason is the table Oil Type is connected using the component. However, if you try to filter on catagory, because of the connection over component, it can only filter on the values hydraulic and transmission, therefore, showing you all categories in these components. I would connect the oil type directly to the BI oil consumption over the category (in the Oil consumption you have that field too and have the component only in the other component table), remove component from the oil type and remove duplicates (in Power Query).
Then filtering works.
Regards,
Oktay
Hi Oktay,
I will try this process,
thanks for your time and effort.
By the way, for MTD I advice using
TOTALMTD(SUM ( 'BI Oil Consumption'[Equipment Quantity] ))
instead of:
Hi,
First, I would have a filter for each field just one Filter function and as the filter fields come from one table, you can combine them into same filter function:
Did I answer your question? Then please mark my post as the solution.
If I helped you, click on the Thumbs Up to give Kudos.
Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
User | Count |
---|---|
87 | |
76 | |
74 | |
55 | |
45 |
User | Count |
---|---|
117 | |
106 | |
77 | |
66 | |
65 |