Introduction To Calculation Groups In Power BI

[@nikeSamotrace]

Finally someone being clear, detailed and concise. Congrats!

[@EnterpriseDNA]

Hi Nicolas, glad that you appreciated our content! If you haven't yet, you can subscribe to our channel to see all our upcoming Power BI video tutorials and announcements. Cheers!

[@brianjulius6401]

Thanks! - Really clear, concise explanation. Very much looking forward to your future videos.

[@HachiAdachi]

Thank you, Mudassir. Question: When the measure slicer was used in the last segment of the video, the matrices did not seem to show the correct answers... would you have to set the relationship between TimeIntelligence table and Measure Select table for it to work properly?

[@hassanulhaq2519]

Well done . Best explanation ever

[@EnterpriseDNA]

Hi Hassan ulhaq, glad you appreciated the video. You can subscribe to our channel to see all our upcoming Power BI video tutorials. Here’s the link: kzbin.info/door/y2rBgj4M1tzK-urTZ28zcA

[@CaiteStevens]

Great clear explanation, thank you so much. Now I finally understand how I can leverage these!

[@joaorataoo]

This is the third explanation I see related to Calculation Groups. The first time I saw an explanation about Calculation Groups, it was scary. In addition to being a new concept, the uses of jargons add denser layer mantle on the subject. How I wish my first explanatory video had been yours! Excellent work. Thanks.

[@EnterpriseDNA]

Hi João Monteiro, glad you appreciated the video. We are so grateful to have had such positive feedback.

[@manohar-kg]

Thanks for this video on calculation group! It would be great if you explain how 2nd metrix is reading measure while changing measure name in slicer. Thanks again

[@nikahafiz1]

actually when mudassir selected sales, the figures for current, pm, pq, mom don't seem to b correct i.e. they r all the same. i also can't get the slicer-measure selector & the corresponding 2nd matrix to work. hope that can b explained again...

[@mudassirsyedrashidali9787]

@@nikahafiz1 In Tabular Editor, when creating slicer-measure selector, try writing the measure i.e. [Total Sales] , [Total Cost & [Total Margin] and it will filter the results you are looking for. I used the whole expression as in my next videos I will be explaining when to hard code the measure, expressions and SelectedMeasure(). Hope it helps!!

[@nikahafiz1]

@@mudassirsyedrashidali9787 many tks fr the clarification, mudassir. actually, i'm looking forward to following-thru on that. my apologies fr 'rushing'. warmest rgds.

[@mudassirsyedrashidali9787]

@@nikahafiz1 No apologies needed. I didn't mention it in the first video because didn't want to make it complex for people who are just starting out in Calculation groups. Thanks a lot for watching the video and hope you will learn with us..

[@khyativyas8004]

Thank you for the explaination, when I am trying the same, I am getting same values for MTD, QTD, YTD etc., Do you know how to resolve it? Or if you have some videos on it could you please point me that?

[@EnterpriseDNA]

Hi @khyativyas8004, The reason why the results could be the same is because you might not have provided date context on your reporting page. Time Intelligence calculations require a date context on a reporting page either within the visual or outside of it, in the form of date slicers/filters. In the given video, if you observe carefully, our expert has provided a context onto the reporting page in the form of a date slicer and therefore, it's calculating the results differently for different metrics. If there's no date field either directly within that visual or onto the report page in the form of slicers or filters then in that case, previous period results will be evaluated the same as current periods due to the absence of date context. Put/give a date context to your visual and you'll see the results getting evaluated properly as expected. For further queries, you can also reach out to us at our Community Forum by providing a detailed description of your query along with relevant files for reference. Our members and team of Experts will be happy to help out! If you haven't yet, do subscribe to our KZbin channel and LinkedIn group to keep posted on the latest data skills and tools updates. Hoping you find this useful! Cheers, Enterprise DNA forum.enterprisedna.co/ www.youtube.com/@EnterpriseDNA www.linkedin.com/groups/12004506/

[@khyativyas8004]

@@EnterpriseDNA Thank you for the reply. Appreciate you taking time out to address the queries here... I tried using Date context too but it doesn't work. In the video above , Mudassir too gets same results for current, PM, PQ, MoM for each month across the table. I am not able to post the snip shot of it but if you forward the video and pause at 13:11, you will be able to see what I mean.

[@deepak.suresh]

Hi, Thanks for the wonderful video and precise explanation. I have this doubt if the calculation groups will work with a model where RLS is implemented?

[@EnterpriseDNA]

Hi Deepak, Thank you for posting your query onto our channel. We really appreciate you taking your valuable time to post it. Well, calculation groups doesn't work in the case of "Row Level Security". Below is the documentation from the Microsoft provided for the reference. But we came across one of the used case as well where calculation groups worked with the RLS. We're providing a link of that blog post for the reference. So we guess that, it also depends on the scenario or use-case as well. For furthermore queries, you can also reach out to us onto our Community Forum where our members as well as experts team will be able to assist you in a better and efficient manner. Below is the link of the forum provided for the reference as well. Hoping you find this useful. Subscribe to our KZbin channel so that you don't miss out on any updates pertaining to the Power BI. You can also join our Power BI group on LinkedIn to receive latest updates on Power BI. Below are the links provided for the reference purposes. Cheers, Enterprise DNA forum.enterprisedna.co/ kzbin.info/door/y2rBgj4M1tzK-urTZ28zcA www.linkedin.com/groups/12004506/ docs.microsoft.com/en-us/analysis-services/tabular-models/calculation-groups medium.com/@curtisrstallings/rls-with-calculation-groups-hierarchy-drill-throughs-power-bi-dax-3a39b668e2b2

[@christophermajka623]

Excellent - thanks for the simple explanation! It makes much more sense to me now

[@EnterpriseDNA]

Hi Christopher Majka, great that you found value in this video. You can subscribe to our channel to see all our upcoming Power BI video tutorials. Here’s the link: kzbin.info/door/y2rBgj4M1tzK-urTZ28zcA

[@sue_bayes]

Really well explained Mudassir, agree with Michelle, functionality fab with clear content.

[@EnterpriseDNA]

Hi Susan Bayes, glad you appreciated the video. We are so grateful to have had such positive feedback.

[@michaeloloishuro6915]

Thanks a lot. This has been very clear.

[@qasimjan5258]

Welcome to youtube Mudassir. Really appreciate your time. I really like your reports. Your visualization work was incredible. Would you go through these reports and show us how you develop these reports? Thank you Mudassir.

[@mudassirsyedrashidali9787]

Thanks. I will be doing that shortly. So stay tuned !!

[@culpritdesign]

When will we get these features in Power BI desktop?

[@RobertoStaltari]

Less scaring now. Thanks Mudassar

[@keagankemp6275]

Aaw thanks for this wow definitely using this !!!

[@EnterpriseDNA]

Hi Keagan, glad that you appreciated our content! If you haven't yet, you can subscribe to our channel to see all our upcoming Power BI video tutorials and announcements. Cheers!

[@rahabrashid3201]

Impressive work 👍 Can't wait to see what you do next.

[@EnterpriseDNA]

Hi Rahab Rashid, glad you appreciated the video. You can subscribe to our channel to see all our upcoming Power BI video tutorials. Here’s the link: kzbin.info/door/y2rBgj4M1tzK-urTZ28zcA

[@yusufgillani532]

This was excellent. I didn't know you could do that. I Didn't know much about Tabular till now. Will you be doing a beginner's course on Tabular Editor on Power BI?

[@mudassirsyedrashidali9787]

Thanks!! Not doing a course but there will be more videos on the application of calculation groups related to real life scenarios.

[@mikeweatherley1548]

I found this useful and very clear but when using the measures in the slicer all the time intelligence calcs are incorrect i.e. Current, PM, PQ and MOM all contain the same values - what is wrong ??

[@EnterpriseDNA]

Hi @mikeweatherley1548, It's a bit difficult to assess and give recommendation without looking at the data structure, model and working of the PBIX file for the reference. You can reach out to us on our Community Forum by providing a detailed description of your query along with relevant files for reference. Our members and team of Experts will be happy to help out! If you haven't yet, do subscribe to our KZbin channel and LinkedIn group to keep posted on the latest data skills and tools updates. Cheers, Enterprise DNA forum.enterprisedna.co/ www.youtube.com/@EnterpriseDNA www.linkedin.com/groups/12004506/

[@trishnasingh3952]

Is there anyway to create calculation group without table editor like dax studio ? Our office doesn't allow table editor.

[@EnterpriseDNA]

Hello Trishna, Thank you for posting your query onto our channel. We really appreciate you taking your valuable time to post. Well, we understand your sentiments here but in this case the answer is - "No, it's not possible to create calculation groups without the use of external tools." Since your office doesn't allows you to download the external tools on your machine, you can opt for portable option where Daniel has explained about this in his discussion with Reid Havens and SQLBI guys. Below is the link of those videos provided for the reference. For furthermore queries, you can also reach out to us onto our Enterprise DNA Community Forum where our members as well as experts team will be able to assist you in a better and efficient manner. Hoping you find this useful. Also, make sure that you're subscribed to our KZbin channel so that you don't miss out on any updates pertaining to the Power BI. You can also join our Power BI group on LinkedIn to receive latest updates on Power BI. Below are the links provided for the reference purposes. Cheers, Enterprise DNA forum.enterprisedna.co/ kzbin.info www.linkedin.com/groups/12004506/ kzbin.info/www/bejne/qF69c4Zop8tpabs kzbin.info/www/bejne/pqWWdZeZn8t8o7s forum.enterprisedna.co/ kzbin.info www.linkedin.com/groups/12004506/ kzbin.info/www/bejne/qF69c4Zop8tpabs kzbin.info/www/bejne/pqWWdZeZn8t8o7s

[@jawadjawaid304]

Amazing well done

[@EnterpriseDNA]

Hi jawad jawaid, glad you appreciated the video. You can subscribe to our channel to see all our upcoming Power BI video tutorials. Here’s the link: kzbin.info/door/y2rBgj4M1tzK-urTZ28zcA

[@natashajawad29]

Excellent. It is very helpful

[@EnterpriseDNA]

Hi Natasha Jawad, glad you appreciated the video. You can subscribe to our channel to see all our upcoming Power BI video tutorials. Here’s the link: kzbin.info/door/y2rBgj4M1tzK-urTZ28zcA

[@wafarashid4857]

Very inspiring! All the motivation is truly in the mindset! I can do it! You can do it! Great Video Spark People!;)

[@EnterpriseDNA]

Hi Wafa Rashid, glad you appreciated the video. You can subscribe to our channel to see all our upcoming Power BI video tutorials. Here’s the link: kzbin.info/door/y2rBgj4M1tzK-urTZ28zcA

[@pratikfutane8131]

Great!

[@EnterpriseDNA]

Hi @pratikfutane8131, we’re glad that you appreciated our content! If you haven't yet, you can subscribe to our channel to see all our upcoming data skills and AI tutorials, and announcements. Cheers!

[@SpeakHearSeeNoEvil]

Amazing. Thank you.

[@EnterpriseDNA]

Hi Godfrey Oyasor, glad you appreciated the video. You can subscribe to our channel to see all our upcoming Power BI video tutorials. Here’s the link: kzbin.info/door/y2rBgj4M1tzK-urTZ28zcA

[@gabrielacostapinheiro5360]

Thank you 🙏🏽

[@EnterpriseDNA]

Hi Gabriela Costa Pinheiro, glad you appreciated the video. You can subscribe to our channel to see all our upcoming Power BI video tutorials. Here’s the link: kzbin.info/door/y2rBgj4M1tzK-urTZ28zcA

[@venkateshns2003]

I am using this calculation group. this is very helpful. I am facing a problem when i export it from power bi service. the problem is - I see the measures like CY,PY,YoY,YoY% CY reach% to PY in columns in the visuals, but when i export this to an excel then these measures are not exported as columns but they are turned into rows and also changes the number formats from %s to numbers. Can you please let me know if you have a solution for this?

[@EnterpriseDNA]

Hello NS Venkatesh, thank you for posting your query onto our channel. Well, whenever you export the data from a visual to the CSV file firstly it'll convert everything to the rows format and it also losses the formatting when exported. There's nothing can be done much about in this type of scenario since there's no significant development in this aspect so far by the Microsoft team. For furthermore queries, you can also reach out to us onto our Community Forum where our members as well as experts team will be able to assist you in a better and efficient manner. Below is the link of the forum provided for the reference. Hoping you find this useful. Happy Learning!!! forum.enterprisedna.co/

[@RonaldJon12]

Good video, just don't get too proudy and friendship will be restored. lol couldn't resist and just kidding.

[@epinedoh]

Thanks!

[@EnterpriseDNA]

Hi Enrique Pinedo, glad you appreciated the video. You can subscribe to our channel to see all our upcoming Power BI video tutorials. Here’s the link: kzbin.info/door/y2rBgj4M1tzK-urTZ28zcA

[@SSM_33]

Awesome Thanks

[@EnterpriseDNA]

Hi said gamal Gx, glad you appreciated the video. You can subscribe to our channel to see all our upcoming Power BI video tutorials. Here’s the link: kzbin.info/door/y2rBgj4M1tzK-urTZ28zcA