ฝัง
- เผยแพร่เมื่อ 25 มิ.ย. 2024
- Here is a nifty CALCULATE function trick to filter between dimension tables or apply a reverse filter from a fact to a dimension table.
Enjoy!
- - - - My Courses - - - -
✔️ Mastering DAX in Power BI -
goodly.co.in/learn-dax-powerbi/
✔️ Power Query Course-
goodly.co.in/learn-power-query/
✔️ Master Excel Step by Step-
goodly.co.in/learn-excel/
✔️ Business Intelligence Dashboards-
goodly.co.in/learn-excel-dash...
- - - - Blog - - - -
goodly.co.in/blog
---
Artist Attribution
Music By: "After The Fall"
Track Name: "Tears Of Gaia"
Published by: Chill Out Records
- Source: goo.gl/fh3rEJ
Official After The Fall TH-cam Channel Below
th-cam.com/channels/GQE.html...
License: Creative Commons Attribution-ShareAlike 4.0 International (CC BY-SA 4.0)
Full license here: creativecommons.org/licenses - วิทยาศาสตร์และเทคโนโลยี
very nice and straightforward! thank you!
Lots of thanks for your support
Awesome Chandeep! Thanks for this interesting lesson. Thumbs up!!
Thanks for sharing! 👍
Amazing, as always :)
Thanks For Sharing.
Great video!
Excellent!
just what i was looking for, thanks!
Glad I could help!
well done, well explained, thanks!
Glad you enjoyed it!
Amazing video, Thanks for sharing.
Just a quick question in terms of Performance -
It is said - to not use a table as filter, Can we optimize this by using one column filter (key column)?
Excellent.
Thanks 😊
Good One.
The trick here is even though you filter by entire sales table DAX engine internally convert this only for filter by customer key in sales table which filters by unique customers.
Really?
Hi, Can we get a workaround that measure can be used as page level filter. Thanks in advance.
hi, awsome technique which is still i still never read even in books. one thing i want to ask is this measure show values after applying RLS?
Thank you! I cannot seem to apply your example to mine. I have two dimension tables: Owners and Customers, and one Fact table: Transactions. Customers is related to Transactions by Customer Number. (Each Customer has an Owner. Owners can own many customers.) I am trying to count the number of Owners whose Customers have at least one transaction on the Transactions table.
Perfect video! but in case if you would like to know - the way you pronounce Year word in English language actually means body part (parts that listen ear) just decided to say it in order to help you improve
How do you display all rows side by side in a matrix visual without using Index column?
Can I just set all the relationships in both directions in the diagram view? Is it a good idea? Its working fine
IS the usage of expanded table to solve the reverse filter?
The concept behind this is expanded table...
Hey, I just tried to open the sample file, however, the link took me on some invalid side where I could not download it. Could you please suggest the way to get it?
From where you get the data.?
Please share the link
is this for programming or accounting, what field is this?
Hi Chandeep. I am still not able to understand how the DAX formula works. How are the duplicates not accounted for in the correct formula?
Please show us how fact table filters dim table in background
So using the obvious/easiest/shortcut....set relation crossfilter to both and a filter on the fact table, filters all the dimensions that are also set both.
is this faster than using something light "treatas" on just a specific column"
I just had one doubt
With your total sales correct measure
After the filter context is applied won't the sales table still have duplicate customer keys ?
Because in dax studio you used values to remove the duplicates
So how is measure functioning correctly then ?
Hi there! I have same question. Did you figure it out? thanks.
Hi Brother, suppose i want account names that have NOT responded in the last 30 days? or say I want names of accounts that have not been active in last 30 days. How to get that data .. pls help Goodly :)
Great why don’t you start Crete a Wtsup group for direct interaction
SHIT you kidding! how this was never mentioned in any documentation!
thanks a lot!
Glad it was helpful!
@GoodlyChandeep please if you can make more use cases like ranking or market share using this method, would be grateful
The definitive guide to DAX 2nd edition page 143: 'you should avoid table filters because they usually are more expensive'
Hi Jan, this isn't same as iterating each row of the Sales table over a FILTER Function.
I am just leveraging the relationship between the Customers and Sales Table by this trick.
This should clarify it further - www.daxpatterns.com/related-distinct-count-excel-2013/
@@GoodlyChandeep Thanks. I will have a look.
@@janwillemvanholst I think here we are looking here at 'Expanded Tables'. A core DAX concept which Alberto & Marco explore in the Definitive Guide.
@@GoodlyChandeep I used the wrong quote. It should have been page 448 '...it is better to avoid using table filters in CALCULATE statements,...'
Thanks a lot Sir....... But you explain very fast...
💚
So you don't need to use CROSSFILTER function?? That's odd!
Hi Bernat,
I also think, that why we are not using cross filter ?
Have you tried this calculation with cross filter ?
Is it giving same result.
@bernat agullo