Clean up your DAX measures with MEASURE TABLES and FOLDERS in Power BI

Рет қаралды 45,340

Күн бұрын

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 KZfaq: 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

Пікірлер: 121

@awarrentfa 2 ай бұрын

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 👀😲

@famousjamous2006 3 жыл бұрын

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.

@HowtoPowerBI 3 жыл бұрын

working on it :D !

@alicedwonderland7733 3 жыл бұрын

I agree - I couldn't find anything as precise for measure tables!

@info2satish 2 жыл бұрын

Was looking for this option in PowerBI, looked through several big KZfaq channels but my search ended here only! 😀🙏

@Picla_Peremohy Жыл бұрын

Now over 122,000 subscribers. Wow!

@brianligat9493 7 ай бұрын

I'm finding your videos much easier to follow than many others. Thankyou.

@gjones86 4 ай бұрын

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.

@diegoamaral290 2 жыл бұрын

That was really satisfying to watch, thanks for the video!

@graemegourlay2850 2 жыл бұрын

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.

@HowtoPowerBI 2 жыл бұрын

the person taking over will be very very happy 😄

@RomainMassau-lw9un 3 ай бұрын

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! ❤

@biswajeetswaro7831 4 жыл бұрын

Great tutorial, previously for copying measures I was doing manually and renaming. Now this will be helpful

@HowtoPowerBI 4 жыл бұрын

Great to hear

@SolutionsAbroad 4 жыл бұрын

Great video, measure table can really help you reign in those measures and calc columns

@HowtoPowerBI 4 жыл бұрын

thanks, Absolutely!

@Soulenergy31 3 жыл бұрын

Thank you bro! 4:14 creating folder

@HowtoPowerBI 3 жыл бұрын

big game changer for keeping those measures nicely organized 😉😀

@elisahorton4833 Жыл бұрын

Best teacher ever! Thank you

@ThrillsofAwe Жыл бұрын

the content is amazing man! big thanks!!

@HowtoPowerBI Жыл бұрын

Glad you think so thx!

@andreashermle2716 4 ай бұрын

you are doing a terrific job. I really love watching your tutorials

@HowtoPowerBI 4 ай бұрын

Glad you like them! thanks a lot Andreas 😊

@Sephraes 7 ай бұрын

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.

@Zachary_Whear 3 жыл бұрын

This was life changing!

@shoeb1359 4 жыл бұрын

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.

@HowtoPowerBI 4 жыл бұрын

Awesome, thank you! really appreciate it!

@sankhlayashraj 6 ай бұрын

THank you Bas for all the knowledge you share. YOU ARE INCREDIBLE. Learnt a lot from you in my journey to build PBI reports.

@HowtoPowerBI 6 ай бұрын

Glad you like them! 😊😁 THANK YOU! happy to hear I can contribute a bit to your journey with my videos

@nataliiaiatsenko7779 2 жыл бұрын

Thanks, brilliant explanation

@lanasedayanoch 2 жыл бұрын

what a beauty. Thanks for the video!

@HowtoPowerBI 2 жыл бұрын

thx Lana!! 😀

@SimohmedRaiss 3 жыл бұрын

Very helpful. Thank you so much.

@HowtoPowerBI 3 жыл бұрын

thanks for the comment! happy it was helpful 😃

@ahmetemin1721 6 ай бұрын

It is a really nice video, thanks a lot for the hard work 👍

@robertmaron1850 3 ай бұрын

Best video I’ve seen on the subject

@HowtoPowerBI 3 ай бұрын

Thats really nice to hear , ☺️ Thanks 🙏

@jitendratrivedi7889 3 жыл бұрын

Great tips for creating Measure folder.

@HowtoPowerBI 3 жыл бұрын

Glad it was helpful!

@vishnurao2901 4 жыл бұрын

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"?

@HowtoPowerBI 4 жыл бұрын

thank you, happy to hear. Will do!

@heatherr5191 4 жыл бұрын

great video - I didn't realize that you could have the same measure in two different display folders :)

@HowtoPowerBI 4 жыл бұрын

thank you!

@ThepExcel 2 жыл бұрын

me neither!

@marlonetzel6450 Ай бұрын

nice video, I will definitely implement this in my future projects

@robsonnascimento5935 4 жыл бұрын

Awesome, thank your for this tips :)

@HowtoPowerBI 4 жыл бұрын

Happy to hear it is helpful!

@jadwiga8759 4 жыл бұрын

Amazing tricks, I can't wait for more videos here :)

@HowtoPowerBI 4 жыл бұрын

great to hear :) more coming soon. Let me know if you have any special requests :)

@Mister_JB_yep 25 күн бұрын

Thank you for sharing!

@HowtoPowerBI 25 күн бұрын

thanks!!!

@engahmedelbendary1566 2 жыл бұрын

thx you for your effort

@ricardopinxt212 2 жыл бұрын

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.......

@josephetorne7226 2 жыл бұрын

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?

@satishkumardommeti8282 Жыл бұрын

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.

@mohammedmansoor65 3 жыл бұрын

Awesome!! Keep Growing!

@adepojuadekunle737 Жыл бұрын

Excellent video. Quite helpful. Can I advise that you minimize your video so and display full screen when you do demo.

@geovanrocha2822 5 ай бұрын

Thanks a lot!

@user-sj5hb3mf2v 2 жыл бұрын

Thank you. Totally great 👍

@HowtoPowerBI 2 жыл бұрын

thank you!!

@mathew9665 Ай бұрын

This is amazing - quick questions, does this also work in Tabular Editor and MS Visual Studio?

@coirolucio 3 жыл бұрын

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!

@HowtoPowerBI 3 жыл бұрын

Hi Lucio, thanks a lot! Measures work independently from where you store them. Maybe you are confused with calculated columns?

@ninadnikam28 Жыл бұрын

woow that a great setup / you we can say good aligns of measure as per the visual name wise

@nataschalaros418 2 жыл бұрын

Hi, great tip again. Can you please explain how to sort on measures, for that does not seem to work ...

@xyclos Жыл бұрын

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

@SabtechOnline 11 ай бұрын

I have been looking for this

@slinger420 2 жыл бұрын

aweome tip on organizing measures.

@HowtoPowerBI Жыл бұрын

Thanks!

@xyclos Жыл бұрын

Thanks a lot Bas

@markhenderson3771 2 жыл бұрын

Great content. Keep up the great work. Also, please take out the background music to make future videos easier to understand.

@HowtoPowerBI 2 жыл бұрын

thanks Mark 🙂

@factswithdaxandpowerbi1008 2 жыл бұрын

very useful information. thanks for sharing.

@HowtoPowerBI 2 жыл бұрын

thanks for watching 🙂

@pravinshingadia7337 2 жыл бұрын

Is there a way to organise tables so we have dimension tables in one folder, fact tables in another, etc?

@zineddine 9 ай бұрын

Nice one, especially placing measures in multiple folders… Any chance you share the file that you have used?

@bdotcoloma Жыл бұрын

Thanks!

@HowtoPowerBI Жыл бұрын

Thanks for supporting my channel Brian :) much appreciated

@filipwinski4219 2 жыл бұрын

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?

@HowtoPowerBI 2 жыл бұрын

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?

@nekkihui9437 29 күн бұрын

very useful to beginner like me:)

@HowtoPowerBI 27 күн бұрын

Glad you think so! 😁

@90s_HipHop 4 жыл бұрын

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?

@HowtoPowerBI 4 жыл бұрын

They will still work :)

@PedroCabraldaCamara 3 жыл бұрын

awesome!!!

@HowtoPowerBI 3 жыл бұрын

Thanks!!

@abubakrsaadmakyhoun7535 4 жыл бұрын

great tips

@HowtoPowerBI 4 жыл бұрын

Thank you

@sathishkumar_bhutharaju 3 жыл бұрын

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!!

@HowtoPowerBI 3 жыл бұрын

Unfortunately not 🙁 folders exist inside of tables, there is no option to have tables in folders.

@sathishkumar_bhutharaju 3 жыл бұрын

@@HowtoPowerBI thanks!!!

@nguyenngothuong 11 ай бұрын

good jobs

@sandymaverick4702 4 жыл бұрын

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.

@HowtoPowerBI 4 жыл бұрын

haha thanks a lot! Do you wanna copy them between different pbi reports? In that case you could do it with Tabular Editor.

@sandymaverick4702 4 жыл бұрын

@@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

@HowtoPowerBI 4 жыл бұрын

@@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 kzfaq.info/get/bejne/ma2eirOmxpPHnaM.html . I believe those are the only 2 options you have without using any external tools.

@alicedwonderland7733 3 жыл бұрын

my dude, this stuff is GOLD! Edit: make that PLATINUM because of the subfolders!

@HowtoPowerBI 3 жыл бұрын

😀 thx so much!!!

@alicedwonderland7733 3 жыл бұрын

@@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 :)

@hafidmes959 9 ай бұрын

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

@341414 3 жыл бұрын

Awesome tips! A question: is it possible to drop a measure on a bootom of a table like implicite measures?

@HowtoPowerBI 3 жыл бұрын

thanks Samir! 🙂 not sure what you mean - where they are showing in the fields pane? .. that's always in alphabetic order, cant change that.

@341414 3 жыл бұрын

@@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)

@341414 3 жыл бұрын

@@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.

@HowtoPowerBI 3 жыл бұрын

@@341414 sure, just send it over to bas.dohmen@datatraining.io .. happy to have a look

@341414 3 жыл бұрын

@@HowtoPowerBI Thank you so much. The mail has been sent.

@nataschalaros418 2 жыл бұрын

Top!

@HowtoPowerBI Жыл бұрын

Thanks Natascha!

@biswajeetnag01 3 жыл бұрын

Awsome

@petecardona8203 Жыл бұрын

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?

@julianatorressanchez5250 Жыл бұрын

It's better if you show the data big and your image small. 👍

@Chris_in_fremantle Жыл бұрын

Genius

@HowtoPowerBI Жыл бұрын

Thx!

@divyamehta6102 3 жыл бұрын

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?

@HowtoPowerBI 3 жыл бұрын

Hi Divya, when you refer to columns you should use the full reference in your calculations --> tablename[columnname]

@adsasd6182 2 жыл бұрын

It´s possible to do that with DAX?

@HowtoPowerBI 2 жыл бұрын

Insert a new table and type in the formula -> Metrics = {("")}

@DB-dz7sm Жыл бұрын

August 2022 Power BI Desktop update breaks the "*" folder shortcut trick

@gracy7063 Жыл бұрын

It's time to clean up your beard also :)

@aashishmeshram9892 11 ай бұрын

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