- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

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:
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.
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!
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

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]))
Did it work ? 👍 A kudos would be appreciated 📢 Mark it as a solution to help spreading knowledge
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

@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:
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

hi @DataVitalizer thanks for the message, I have tried your formula but without luck, the result is not what I expected:
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

Can you share with me that first table as a data sample so I can use it to verify the fomula again?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

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]))
Did it work ? 👍 A kudos would be appreciated 📢 Mark it as a solution to help spreading knowledge

Helpful resources
Subject | Author | Posted | |
---|---|---|---|
04-18-2024 01:14 PM | |||
08-13-2024 11:02 AM | |||
07-30-2024 09:31 AM | |||
02-13-2024 03:36 AM | |||
06-07-2024 04:06 AM |
User | Count |
---|---|
141 | |
115 | |
84 | |
63 | |
48 |