Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.

Reply
Simon3
Frequent Visitor

dynamic division DAX column

Hi everyone, I am still new to Powerbi and I can't get around the calculate function well... I have the following table:

Simon3_1-1690799206417.png

my goal is to have a column that returns the correct division (sum of DDF components / sum of DD1 components). for this I have first created a simple calculated colum that does it correctly. 

However, if I remove the column BuildingCZ the calculation gets aggregated with sum and returns a value that I don't need.

Simon3_2-1690799471762.png

instead of getting 1.40 how can I get the result of 42855/191131 ?

 

I hope that I was clear, I am pretty sure that I need to use the calculate function but I can't understand how exactly, any help would be highly appreciated!

 

1 ACCEPTED SOLUTION

I guess this measure is suffisant, but this will not give 2.63 in total

MyMeasure = 
DIVIDE(
SUM(exampledataset[DDF components]),SUM(exampledataset[DD1 components]))
othy_bi_2-1690807997007.png

Did it work ?  👍 A kudos would be appreciated ‌‌📢 Mark it as a solution to help spreading knowledge

View solution in original post

6 REPLIES 6
Simon3
Frequent Visitor

@DataVitalizer I know that I marked the thread as resolved but can I ask an additional question related to this topic?
I went on and created a new measure as per below: 

Simon3_0-1690811867882.png

If I remove the column discipline from the second table all the PV2 values become strange, any idea why? 
If this post is against the rule I will open a new thread.

 

DataVitalizer
Solution Sage
Solution Sage

Hi @Simon3 

You are supposed to sum up the division per row, to do so create the following Measure

 

MyMeasure=
SUMX(
ALLSELECTED(MyTable[Discipline]),
DIVIDE(SUM(MyTable[DDF components]),SUM(MyTable[DD1 components]))
)


Did it work ? 👍 A kudos would be appreciated ‌‌📢 Mark it as a solution to help spreading knowledge

hi @DataVitalizer thanks for the message, I have tried your formula but without luck, the result is not what I expected:

Simon3_0-1690805212394.png

 

Can you share with me that first table as a data sample so I can use it to verify the fomula again?

Sure, here you go! https://we.tl/t-Bz9gldCOCI

I guess this measure is suffisant, but this will not give 2.63 in total

MyMeasure = 
DIVIDE(
SUM(exampledataset[DDF components]),SUM(exampledataset[DD1 components]))
othy_bi_2-1690807997007.png

Did it work ?  👍 A kudos would be appreciated ‌‌📢 Mark it as a solution to help spreading knowledge

Helpful resources

Announcements
Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

Jan NL Carousel

Fabric Community Update - January 2025

Find out what's new and trending in the Fabric community.