Use Measures as Columns Using Calculation Group in Power BI

In this tutorial, you'll learn how to use measures as columns in Power BI by using calculation groups. We will create a highly customized table visualization with columns representing various measures. We used Tabular Editor, an external tool, to create and manage calculation groups in Power BI.

===== ONLINE COURSES =====
✔️ Mastering DAX in Power BI -

✔️ Power Query Course-

✔️ Master Excel Step by Step-

✔️ Business Intelligence Dashboards-

===== LINKS 🔗 =====

===== CONTACT 🌐 =====

===== WHO AM I? =====
A lot of people think that my name is Goodly, it's NOT ;)
My name is Chandeep. Goodly is my full-time venture where I share what I learn about Excel and Power BI.
Please browse around, you'd find a ton of interesting videos that I have created :) Cheers!

[MilhouseBS]

A lot of BI goodness in 10 minutes! Thanks.

[jahmed]

This is Gold!!! I was totally scratching my head on how to do it in a Matrix instead of a flat table. Tabluar Editor for the win!!

[BISimplifier]

Great .
One thing i like very much you explain the base concept again (e:g:calculation group) for the complete new comer to understand the overall content well.
This is well aligned with Alberto's calc presentation.

[olunugaoladipupo]

This blew me of my feet! Wonderful. Thank you so much!

[abtotheku]

You are the best. We learn a lot from you.

[danishnawaz]

Plz make Video for below Formula "Power Query", Video Time Fram is Max 10mint
1. List.RemoveMatchingItems
2. List.ReplaceMatchingItems
3. List.TransformMany
4. List.ReplaceValue
5. List.PositionOfAny
6. List.PositionOf
7. List.NonNullCount
8. List.Intersect
9. List.Durations
10. List.Difference
11. List.FindText
12. List.InsertRange
13. List.Union

[Evaldas]

This is a common requirement of my clients, going to experiment with this, thanks! Still, it's a bit odd that PowerBI doesn't support this kind of thing my default (custom measures in a matrix after totals)...

[priyeshsanghvi]

💥Awesome application and clarity in = GOLDLY !!

[chrisinbcn]

Hello Chandeep, great video as usual! Would you be so kind to share also the source of the sentiment symbol to put next to the measure in the formatting window? I am struggling as I don't know where to find it. Thank you!

[JamesMazzanti]

Great video. I’m struggling with calculation groups as columns and calculation groups as rows at same time, I’ve experimented with precedence but no luck yet. Any videos of yours on this challenge?

[mahathivucha]

Did anyone face the issue of not getting the "drill on - Columns" option at all?

[arbazahmad]

It's great 👍 hope will use this in PBI desktop.

[etienneborella]

Such a clever and powerful trick! thanks a lot for this :-)

[ankushroy]

I am considering Total Units, I need to show those products only where no blank data is present for selected quarter. How it can be achieved.

[pillslifestylereviews]

Can you please make a video for Moving Range. I can't figure out how to do it without using Verus Previous in Visual Calculations.

[oksanakiselova]

Hi,
thank you for the video! It is really helpful!
I would like to ask if it is possible to use another tool similar to Tabular Editor?
Thank you!

[hsilva]

Great explanation Goodly, thank you!!. would this measure as column behave the sane way if we do analyze in excel?

[davidlaid-urxn]

What should be the DAX for calculation items, if we are not selecting the measures from the parameters, but instead we want to drag and drop the measures in the matrix visual

[ArmanAper]

Hi, thanks for your videos, they are amazing.

Can you please, help to solve the problem with customized table
I need to show YTD Amount in Matrix (up to selected Month) in one column and YTG Amounts by months (several columns). For example, if a user chooses 10th month, the matrix should show YTD (up to 10 th month in 1 st column than, 11 and 12 month separetely.

Thanks in advance.

[ajay]

@Goodly how to get the "Drill-On" columns, anyone can you help please.