Clean up your DAX measures with MEASURE TABLES and FOLDERS in Power BI
ฝัง
- เผยแพร่เมื่อ 21 ก.ค. 2024
- Learn how to organise your DAX measures effectively in Power BI- with measure tables and folders.
Download file here datatraining.io/powerbi-how-to
--------------------------------
📊 TRAININGS 📊
---------------------------------
Power BI Design 4 Weeks Transformation Program my.datatraining.io/pages/powe...
Power BI Essentials datatraining.io/powerbilearni...
Business User Training datatraining.io/powerbi-busin...
For Custom Trainings and Consulting email directly support@datatraining.io
---------------------------------
😍 JOIN 😍
----------------------------------
Join bit.ly/4b453bi
Subscribe bit.ly/31MnQGO
Insta / howtopowerbi
LinkedIn / basdohmen
TikTok / how.to.power.bi
X / howtopowerbi
fb / howtopowerbi
Threads www.threads.net/@howtopowerbi
Newsletter datatraining.io/newsletter
---------------------------------
👇 CHECK THIS OUT! 👇
---------------------------------
💻 My gear amzn.to/47F21Yc
📚 Power BI books MUST READ! amzn.to/3tUfFcj
💡 General books I recommend amzn.to/48YNo33
🎶 Music for my videos www.epidemicsound.com/referra...
🚀 For growing on TH-cam: www.tubebuddy.com/bas
🏄 Stuff I use daily amzn.to/3HqfMQ2
* Above are affiliate links, which means at no additional cost to you, if you make a purchase using these links we will receive a small commission. It supports us and helps us to continue making more How to Power BI videos!
Thanks for being a part of this channel and all your support! 💪 🙏
#HowToPowerBI #PowerBI #DataTraining
#powerbidesktop #powerbitraining #powerbideveloper #DAX - วิทยาศาสตร์และเทคโนโลยี
The way that my eyes went wide and my jaw dropped when you demonstrated how to show the same measure in multiple folders at the same time 👀😲
How is it this channel has less than 1000 subscribers? You have great content! I hope the channel blows up for you, you’ve clearly put a lot into your videos and I look forward to seeing more.
working on it :D !
I agree - I couldn't find anything as precise for measure tables!
Was looking for this option in PowerBI, looked through several big TH-cam channels but my search ended here only! 😀🙏
Now over 122,000 subscribers. Wow!
I'm finding your videos much easier to follow than many others. Thankyou.
I'm very new to Power BI and your channel already helped me so so much! But this kind of "good practices" video gives me "oh my god, why didn't I do that before?" moments! Thanks! Plus it's in a short format so it makes it a "quick-learn" which can actually turn into a life-saver for newbies like me! Keep up the great work and quality content! ❤
Thanks for this Bas. You're the best at explaining PowerBI with straightforward, clear instructions and many of your videos have helped me out, particularly this one. Keep up the great work.
Really nice, I'm doing a piece of work where I will need to handover the maintenance of the report to someone else. Keeping things super-clean with organisation of the data will make a positive difference. I'm implementing what you have demonstrated in this video. Nice.
the person taking over will be very very happy 😄
I looked online, and I I could not find the subfolder info until today. People kept saying that was impossible, and today I'm finding out it's been there the whole time. Very frustrating and also very happy at the same time.
That was really satisfying to watch, thanks for the video!
THank you Bas for all the knowledge you share. YOU ARE INCREDIBLE. Learnt a lot from you in my journey to build PBI reports.
Glad you like them! 😊😁 THANK YOU! happy to hear I can contribute a bit to your journey with my videos
Great tutorial, previously for copying measures I was doing manually and renaming. Now this will be helpful
Great to hear
Thank you bro!
4:14 creating folder
big game changer for keeping those measures nicely organized 😉😀
Great. Just great.
I also like everything nice sorted and organized.
Could not find good clear guidance on creating a metrics table.
Should have known I first should have searched in your content.......
Best teacher ever! Thank you
you are doing a terrific job. I really love watching your tutorials
Glad you like them! thanks a lot Andreas 😊
Excellent video. Quite helpful. Can I advise that you minimize your video so and display full screen when you do demo.
what a beauty. Thanks for the video!
thx Lana!! 😀
Superb !!!
Thanks for Sharing.Your video's are really good and everything is properly explained.
Going to recommend your channels in my Power BI Watsapp groups.
Awesome, thank you! really appreciate it!
nice video, I will definitely implement this in my future projects
It is a really nice video, thanks a lot for the hard work 👍
the content is amazing man! big thanks!!
Glad you think so thx!
Best video I’ve seen on the subject
Thats really nice to hear , ☺️ Thanks 🙏
Thanks, brilliant explanation
This was life changing!
Really awesome man! I copied this method, but when I tried to export the underlying data, it only shows the measures and the rest of the underlying rows of data is missing. Any thoughts?
Is there a way to organise tables so we have dimension tables in one folder, fact tables in another, etc?
Great tips for creating Measure folder.
Glad it was helpful!
Very helpful. Thank you so much.
thanks for the comment! happy it was helpful 😃
woow that a great setup / you we can say good aligns of measure as per the visual name wise
Nice one, especially placing measures in multiple folders… Any chance you share the file that you have used?
Amazing tricks, I can't wait for more videos here :)
great to hear :) more coming soon. Let me know if you have any special requests :)
great video - I didn't realize that you could have the same measure in two different display folders :)
thank you!
me neither!
Great video, measure table can really help you reign in those measures and calc columns
thanks, Absolutely!
Excellent recommendation to organize Measures.
I have a question here:
1. I created a host of measures in my SSAS Model. Can I organize it in similar manner? Please guide.
2. While working, I have also created many measures and surely there are some that are no longer used in my report. Is there a quick way to identify them?
3. If I were to alter my measure name, I need to remember which visuals were they used and fix them one at a time. Is there a better and easier way to achieve this?
Advance Thanks.
This is amazing - quick questions, does this also work in Tabular Editor and MS Visual Studio?
Great information..👍I was searching for this.. Thank you for uploading this video. I request you to please make video on " How to publish dashboard/reports to On-premises server"?
thank you, happy to hear. Will do!
Awesome!! Keep Growing!
Awesome, thank your for this tips :)
Happy to hear it is helpful!
aweome tip on organizing measures.
Thanks!
thx you for your effort
Thank you for sharing!
thanks!!!
THis was great, but after moving all my measures to a new table, they all got errors. Can you explain why and how to fix it?
Hello, could you help me please: how can i select the earlest date from several dates? I have several columns with dates and i would like to create a new column in which i can see the earlest date of each line. Hope you got my question 😢
Thanks
Great video! Could you briefly explain how the measures still work even if they are in another table which isn't connected to the rest of the tables? Why filters and everything still work?
Thank you!
Hi Lucio, thanks a lot! Measures work independently from where you store them. Maybe you are confused with calculated columns?
Hi, great tip again. Can you please explain how to sort on measures, for that does not seem to work ...
Everything in Power Bi is sorted in alphabetical order..tables, column names,,,so to control this you can initiate a name with a number: 01 Measure name, 05 columna name just as he said during the video
very useful information. thanks for sharing.
thanks for watching 🙂
Thanks a lot Bas
Thank you. Totally great 👍
thank you!!
Thanks a lot!
I have been looking for this
It's better if you show the data big and your image small. 👍
very useful to beginner like me:)
Glad you think so! 😁
Great content. Keep up the great work. Also, please take out the background music to make future videos easier to understand.
thanks Mark 🙂
If you have measures in an existing report and decide to move them into a measures table and the folder structure, do you know if it will break any of the previously created visuals?
They will still work :)
Thanks!
Thanks for supporting my channel Brian :) much appreciated
Wow!!! Great content as always. I didn't know the ; tip. Just one question: I'm not sure but I've heard that organizing measures in separate table can affect samrt narratives - truth or myth?
thank you Filip! seems to work for me .. not sure what specific cases that could be where it would have an impact... or maybe an issue in older pbi versions?
my dude, this stuff is GOLD! Edit: make that PLATINUM because of the subfolders!
😀 thx so much!!!
@@HowtoPowerBI I would add one thing: careful about reports that already use the measures from their previous location. Those reports will display only errors. Unfortunately, you'd have to replace the measure with itself. Learned that today the hard way :)
awesome!!!
Thanks!!
Hi Great Video!
I have one doubt,I have multiple tables if there is any chance to move tables or columns into this folder? like below 1)folder1-->table1-->table1measures
2)folder2-->table2-->table2measures
thanks in advance!!
Unfortunately not 🙁 folders exist inside of tables, there is no option to have tables in folders.
@@HowtoPowerBI thanks!!!
Hi! I did transfer one DAX measure to newly created folder, but I do get an error : " Column cannot be found or used in expression". How should I deal with this?
Hi Divya, when you refer to columns you should use the full reference in your calculations --> tablename[columnname]
great tips
Thank you
good jobs
Awesome beard and oh well, nice tips ;) Any idea to make a copy of measures quickly. Currently I do it by copying it from the formula bar.
haha thanks a lot! Do you wanna copy them between different pbi reports? In that case you could do it with Tabular Editor.
@@HowtoPowerBI well not really, copying in the same file. For example, I have made a sales value measure, and want to make for sales units, i just want to copy sales value measure and change it to units. Also I have actual, budget as two different fact tables, and just want to replicate actual measure to budget by just copying and changing to budget table
@@sandymaverick4702 The only other way that I know is by using the modeling view, selecting the measure and then duplicating it to different tables/folders in the modeling view as shown from minute 7:10 th-cam.com/video/cGnWPua-cmo/w-d-xo.html . I believe those are the only 2 options you have without using any external tools.
Awesome tips!
A question: is it possible to drop a measure on a bootom of a table like implicite measures?
thanks Samir! 🙂 not sure what you mean - where they are showing in the fields pane? .. that's always in alphabetic order, cant change that.
@@HowtoPowerBI
I need to calculate the average age of this list.
The Table visualization does the job this very well with an implicit measure at the bottom of the table.
I would like to replace this implicit measure with an explicit measure and place at the same place: bottom of the list.
My question: how do I place an explicit measure (I have created) at the bottom of a table, such as the average of a list?
I don't know if this is clear.
Translated with www.DeepL.com/Translator (free version)
@@HowtoPowerBI
Hello,
I don't want to take advantage of your kindness. I have a simple problem but I can't explain it well in the screenshot.
Do you have a way for me to send you a screenshot that explains my problem please?
Thank you in advance.
@@341414 sure, just send it over to bas.dohmen@datatraining.io .. happy to have a look
@@HowtoPowerBI
Thank you so much.
The mail has been sent.
Awsome
Top!
Thanks Natascha!
It´s possible to do that with DAX?
Insert a new table and type in the formula -> Metrics = {("")}
Genius
Thx!
August 2022 Power BI Desktop update breaks the "*" folder shortcut trick
It's time to clean up your beard also :)
Hello,
I need yours assistance for one thing -
I have two different table - Table1 & Table2
Both tables has records with n number of columns, one column is common in both table which is Country. table2 has another field called Status=Active, Inactive.
so I want a one output Matrix Table (similarly mentioned below), where I want to get the Count of both tables based on Country
Condition:
Table1: no condition (count)
Table2 : based on Status = Active (countif)
Country Count from Table1 Count from Table2
-------------------------------------------------------------------------------------------------------------------
India 23 39
Canada 44 48
Brazil 51 7
United States 17 73
how we can get it in Power Bi, i have made but second table count coming sum of table2 in each row.. please help