Reply
Simon3
Frequent Visitor
Partially syndicated - Outbound

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

Syndicated - Outbound

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

Syndicated - Outbound

@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

Syndicated - Outbound

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

Syndicated - Outbound

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

 

Syndicated - Outbound

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

Syndicated - Outbound

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

Syndicated - Outbound

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

avatar user

Helpful resources

Announcements
March PBI video - carousel

Power BI Monthly Update - March 2025

Check out the March 2025 Power BI update to learn about new features.

March2025 Carousel

Fabric Community Update - March 2025

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

Top Solution Authors (Last Month)
Top Kudoed Authors (Last Month)