Save HOURS by Reusing Multiple Measures in Calculation Groups | Power BI

In this video, I show you how you can easily set up measures, like time intelligence ones for MTD, QTD and YTD, just once, and then reuse them on any measure without needing to recreate multiple versions, all using calculation groups in Tabular Editor 2, and also sort by any column too.
#powerbi #dax #measures #calculationgroups
🔗 Link to Tabular Editor
www.sqlbi.com/tools/tabular-e...
▶️ Link to how to create the dashboard shown in this video
• 💡How to create a Power...
🔖c h a p t e r s 🔖
00:00 - Intro
00:30 - Get tabular editor
01:32 - Create a calculation group
02:19 - Create a calculation item
03:17 - Add your calculation item to a visual
04:34 - Add additional calculation items
06:06 - Explaining measures created
07:20 - View a different metric / measure
08:13 - Create a column sort filter
12:56 - Select only columns needed
13:11 - Use field parameter to select values
💌 My email - [e-mail]
🌍 My website - www.deanchereden.com
🐦 Twitter - / deanchereden
🎵 Vhsceral - Gimetime chll.to/dd82e17f
🎶 Listen to Chillhop Music - • Misha & Jussi Halme - ...

[@alansnyder6565]

There is an easy work around to losing the sorting ordinality when using Field Parameters and Calculation Groups.
Interestingly the default in Power BI when a Sort By Item is selected is Descending, but if you lose the sort item, which you do with Calculation Groups and Field Parameters, the default sort order becomes Ascending. So you could change the ordinality in Tabular Editor to 1 instead of -1, or you can solve it with a calculated sort column. Most people have a serial column for week, month and quarter, and years are already an ascending serial number.
SO, to Solve this very problem in our tables and matrixes, we created a "sort by column" which simply multiplies the serial month, week, quarter, or the year by -1. This will create an opposing directional serial listing that can then be used as a sort order for the Week, Month, quarter or year.
CRITICAL: Do not select a Sort By Item on the visual, and the problem is solved. If you need to switch directions, simply change the sort order for your date TABLE columns to be by the serial number instead of the negative serial number. Simple but it works.

[@zakariatamide6584]

Hello ! Good, thank you for this vidéo (y)
Well, what about formating measures in calculation group with colors for example ? like the first table with multiple measures

[@DeanChereden]

Hey, I covered that in a later video ruclips.net/video/MbxJ1oHHyTg/видео.html

[@cashingout6373]

Can you go over on how to do conditional formatting to these columns, such as if you just wanted to format % column and not the MoM column

[@DeanChereden]

For a single column you can use the below measure to be applied to the conditional formatting if you have a calculated item called MoM % and want to apply it to the measure total sales.
One Measure Cond Format =
IF(
SELECTEDVALUE('Select Period'[Period]) IN {"MoM %"},
[Total Sales],
BLANK()
)
There's a bit more to it for field parameters so I'll do a quick video over the next week to explain in more detail as it's hard to cover all in a comment with visual aids 😀

[@DeanChereden]

I have published a video that covers this now 🙂 ruclips.net/video/MbxJ1oHHyTg/видео.html