what if the data is coming from two different tables and there was an additional layer of hierarchy between retailer type and product line, lets say it goes retailer type -> product type -> product line -> retailer country (where product type is coming from another table called "Products" what changes do we have to make to the dax to incorporate product type and ensure that when product type is expanded from retailer type, the proper subtotal of that category is shown. Thank you
@rmccallen
3 жыл бұрын
Excellent solution to a problem I have been struggling with, this will save so much time
@BIElite
3 жыл бұрын
Very happy to hear, Roger!
@ajaaskelainen
4 жыл бұрын
I especially loved the usage of "Switch", "True" & "IsInScope" functions as well as using "Values"! It's great!
@BIElite
4 жыл бұрын
A lot of good stuff here 😊
@yzarelloso
Жыл бұрын
Thank you so much for this video and the blog post. It was a great help, i was able to fix my visual for decomposition tree in percentage instead of whole numbers. Continue doing what you are doing.
@mellocamilo
4 жыл бұрын
Greatest tip for subtotals percentages in hierarchies! Thanks! It helped me a lot!
@BIElite
4 жыл бұрын
Glad to hear, Camilo!
@melvin9993
3 жыл бұрын
This is exactly what I was desperately looking for 👌👌👌👌👌👌👌✔
@BIElite
3 жыл бұрын
Nice! Great to hear Melvin
@bharathkumarvj4578
Жыл бұрын
Osum.... it worked and I learnt on how to do it. Thanks.
@Titusissam
4 жыл бұрын
Awesome really searching for this solution for almost 3 Months, at-last got it. Thanks.. :)
@shivamsarin1
2 жыл бұрын
Thank you so much!! You're a genius & a lifesaver.
@felipearruda2112
3 жыл бұрын
Man, this is awesome. Thank you, thank you. thank you!
@hardiyakubu8800
3 жыл бұрын
I tried it but I got two error messages. First one, ALLSELECTED does not accept two arguments where a table is the first argument. Second one it showed a messaged saying, TRUE needs a column to work. Could you please help?
@efthimiosspiridopoulos9531
4 жыл бұрын
Great feature there! But what if our visual is not static (in the order of levels presented) and for example we need to remove the 'Retailer type'? Then all Product line options will show 100%. Is that possible to do? Also, is it possible to keep both % and value in this visual?
@user-md4is2ye8r
7 ай бұрын
THANK YOU!
@symkly
10 ай бұрын
thank you for sharing this video, it is very nice. But the calculation fails once I change the hierarchy. Is there any way to leverage this ?
@Checkmate234
4 жыл бұрын
Very informative, concise, precise :D I like it. Will most certainly put this to use in future
@BIElite
4 жыл бұрын
Great to hear that, Ruan!
@informaticosupertrans8132
3 жыл бұрын
it work fine, but it cost me to realise that the "page filter" didnt filter in the formula, is a way that page or all page filters woks with this one?
@LidiaMoreira_RendaMais
3 жыл бұрын
Thank you so much for this video!
@adityasinha5167
2 жыл бұрын
Thanks a lot. It works perfect!
@michaelc.751
4 жыл бұрын
Nice use of isinscope(). However, In the settings of the visuals you could also toggle with the node level, from where you see the percentages (parent node etc.).. Did you see that?
@BIElite
4 жыл бұрын
Yes, I found that out after this video was published. I guess I should have shown this method primarily with the matrix visual, but the decomposition tree is so nice to look at.
@gtimis
3 жыл бұрын
I love you right now! THANKS :)
@sandiptalekar6188
Жыл бұрын
Thanks for this information about decomposition tree. Here the bar represents the Revenue numbers. Can we convert these bars into bubbles where each bubble can be resized according to the Sales?
@lukasmartin2076
3 жыл бұрын
Great solution. In the final visual I want to show only my own brands. Otherwise it`s hard to find own brands in the many competitors brands. A normal filter does not work. Can you help?
@shubhamjante
3 жыл бұрын
This is what I was looking for except, Can we have dynamic levels with the same logic? For me it's really important for one of my business-critical charts. Thanks in advance.
@EmanuelPereiradeSouza
Жыл бұрын
Amazing!!!
@chadklopfenstein6394
4 жыл бұрын
Brilliant... now I don't have to work all weekend :)
@ananyakulshreshtha2807
5 ай бұрын
How to have sum and % contribution both at data value
@rakshitbhatnagar4777
3 жыл бұрын
How can we calculate average revenue in absolute terms (not percentages)?
@alanchoy2704
3 жыл бұрын
This is great, thank you! Is there a way you think we can make this flexible to take advantage of the AI's autoselections?
@ismailk6089
3 жыл бұрын
Hi thank you for sharing the video, but still it is not working for matrix visuals. How can I do that IN matrix visuals?
@richardtibbs382
3 жыл бұрын
Where he has ALL(...), I had to do ALLEXCEPT() to exclude my column headers. Hope that helps
@richardtibbs382
3 жыл бұрын
This works so well! In a matrix, how would you handle a column hierarchy of another table joined to the date of the main table ?
@officesuperhero9611
4 жыл бұрын
Hi Parker, in this example, I find that the user would have to select/apply the filters in the order that the measure is written in or it does not calculate correctly. Is there a workaround?
@BIElite
4 жыл бұрын
Hi Richard, not that I know of. The Decomposition Tree is the only visual that let's you choose the path of categories (excluding personalized visuals). I only know of this method to hard code the a single, proper order.
@jimayas
2 жыл бұрын
Please evaluate this DAX; why do you have to be so complicated? This should have been an option inside the chart.... Great explanation by the way
@andresmalavenda3847
4 жыл бұрын
What is the name of the decomposition tree in the marketplace?
@BIElite
4 жыл бұрын
It's actually not in the marketplace. You need to enable the decomposition tree preview feature. Once you restart Power BI, the decomp tree will show in your native Power BI visuals
@Baldur1005
4 жыл бұрын
Can you modify the measure so it can work, even you will play with dimensions order? I guess it's possible but a little longer as you have 15 combinations… A _ _ || A B _ || A B C || A C _ || A C B || B _ _ || B A _ || B A C || B C _ || B C A || C _ _ || C A _ || C A B || C B _ || C B A - your scenario cover 3 combinations… so it should be just few tweaks and we are done
@BIElite
4 жыл бұрын
Very true. I meant to explain in the video that you could write a bunch of DAX to handle all hierarchy orders. I appreciate the comment!
@KA-rk9to
4 жыл бұрын
I am trying exactly that, but can't make it work. If you happen to have a real life DAX code example could you please share?
@rakshitbhatnagar4777
3 жыл бұрын
I am looking for the same functionality and trying to figure out how to modify the formula, did anyone here was successful with it?
@impala4641
4 жыл бұрын
Very nice! I will try this
@BIElite
4 жыл бұрын
Thanks for watching!
@decentmendreams
4 жыл бұрын
Thank you so much Parker. An awesome video...Q: is it possible to attach a second measure to this? I want to show if an item is up or down (period variances). Thank you so much. I always watch your videos..
@kennethsmith9610
Жыл бұрын
This is great. But it is only good for a single period. In a Matrix, if you had Years (periods) in your columns, only the Total column maintains its integrity, the individual Years (periods) would reflect their individual share of the Total column.
@atiqkhan9637
4 жыл бұрын
what is the name of this visual ? its awesome
@BIElite
4 жыл бұрын
Decomposition tree! I believe it’s still in preview so you need to enable it in the preview feature settings.
@feng3625
4 жыл бұрын
So great
@BIElite
4 жыл бұрын
Thank you very much, Feng!
@edgarsalgueiro6281
7 ай бұрын
that's all very nice but the user can change the order and then it doesn't work...
@ed2921
4 жыл бұрын
What’s up Parker. Nice job.
@BIElite
4 жыл бұрын
Thanks Ed!
@NarendraSunku
4 жыл бұрын
Nice video. What is the key board shortcut to comment multiple lines in one go?
Пікірлер: 60