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

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

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
Super User
Super User

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
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

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