SUM function not working?

[sy898661]

Hi, can someone explain to me what I'm doing wrong?!?!

*ATS = Adherence to Schedule (DATEDIFF of Planned and Actual completion)

I have this calculated column full of 0's and 1's saying if the ATS column is not blank and = 0, 1, otherwise 0.

STEP10 ATS On Time = If(AND(NOT ISBLANK('Query'[STEP10 ATS]),'Query'[STEP10 ATS] = 0), 1, 0)

And when I filter the column to only show 1's, we get 13 of them (so 13 rows are not blank and =0, meaning they are on time).

So I created this simple measure:

STEP10 SUM ATS On Time = SUM('Query'[STEP10 ATS On Time])

But when I put that measure on a card to see what it came up with.... it says 2. what?!

Am I using the wrong function? Is this saying there are 2 values instead of actually summing up all the 1's?!

What do I doooo 😞

Thank you so much!

[sy898661]

Note:

I also have a column that sums all the ATS's

and that total gives me 28 (when i put the measure on the card)

But when I run my measure that is:

DIVIDE(SUM(ATS On Time), SUM(ATS Count))

the measure says 13% ............ 2/28 = 7.14%

Why isnt this working? 😞

[v-shex-msft · Accepted solution]

Hi @sy898661 ,

Current power bi not support to create dynamic calculate column/table based on filter/slicer, you can only use measure to achieve dynamic result based on filters.

Filters are works on visual level which generated from data model tables. Filter will update if any changes apply on its parent.(data model table)
Calculated column/table are stored on data model level, you can use parent level(data model) to update its child(measure, visual, filter, data view level) but it is impossible to use child to effect parent.
Regards,

Xiaoxin Sheng

[sy898661]

Thank you @v-shex-msft for explaining that! 🙂