DAX row calculation

[haassiej]

Hi All,

I'm trying to find a way to solve the following problem and could really use some help..

As you can see in the screenshot below, I have a table with payment amounts and (in the two last rows) day amounts. These two types of amounts (or units) were originally combined in a single column which was pretty confusing.

However, I managed to create a new measure 'budget' which returns day amounts where the category is about 'Days' and returns 0's or empty fields where we're not talking about 'Days' but payment amounts. 

What I'm trying to achieve now is a row-based calculation where I can divide a payment amount by 'A Days' or 'B Days' etc. etc..

(Payment Amount / A Days)

So basically; how do I transpose the row A Days (value = 22865) into a column that shows this value for each 'payment category'?

Any help is very much appreciated!

Thanks and kind regards

[v-qiuyu-msft · Accepted solution]

Hi @haassiej,

Based on my understanding, you want to divide column C= Budget (Measure) by the Budget values hen it's equal to " A Days", right?

You can try to create a measure like this:

Column = var ADays=CALCULATE([Budget],FILTER(ALL('<TableName>'),Accountgroups="A Days"))
return
DIVIDE([Budget], ADays)

Best Regards,
QiuyunYu

[haassiej]

@Greg_Deckler

From left to right:

Column 1 = Accountgroups

A = Actuals (Measure)

B = Actuals YTD (Measure)

C = Budget (Measure)

D = Budgets YTD (Measure)

Budget = Statistical measure of day numbers

The statistical days were booked on 2 accountgroups (A days and B days). I would like to calculate with these values. As Example for accountgroup 10:

Column C   (divide)     Column Budget
Budget          /             Statistical days (Budget column)

[Greg_Deckler]

Can you provide some sample data and your formulas? What is A Days, is that a column, measure or ?