Might be possible power bi is miscalculating an easy row

[Anonymous]

Hello everybody,

i have just have a question about power bi.

Might be possible power bi is miscalculating?

I have the following table and the result of the column should be 734 and not 733.

Does anybody why?

Thanks

cfreiburg

[amitchandak]

@Anonymous , can share the calculation. and check the row count at source and power bi same

[Anonymous]

Hi @amitchandak  and @Fowmy ,

the measure I use for the calculation:

Soll-W in Sek = CALCULATE(SUM('Tab_Kapapzitäten_Soll_IST_Werte'[Laufzeit in SEK]),'Tab_Kapapzitäten_Soll_IST_Werte'[Katergorie]="Soll-Werte")

The other way is I just put column [Laufzeit in SEK] in the table and I use the visual filter with "Soll-Werte", I get the same result = 733.

The values of my data base are fine.

cfreiburg

[v-juanli-msft]

Hi @Anonymous 

I can't reproduce your problem on my side.

Could you show some example for me to test?

For example,export data of the visual which causes problems, then remove privacy data and share with us.

Best Regards
Maggie
Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

Hi everybody,

i created a test version of my data set to find my failure. Hopefully it helps!

https://www.dropbox.com/s/49arffeuprcyvqv/Test_Controlling_Prod_V1.1.pbix?dl=0 

If you have time, please have look on it. The problem drives me crazy.

I am thankfull for every help I can get by you.

freiburgc

[Fowmy · Accepted solution]

@Anonymous 

Try this measure for Deviation. 

Deviation =
VAR T =
    CALCULATE (
        SUM ( Capacity_Target_Actual_Value[Modified Value in sec] ),
        Capacity_Target_Actual_Value[Category] = "Target-Value",
        Capacity_Target_Actual_Value[Attribut] = "Run Time"
    )
VAR A =
    CALCULATE (
        SUM ( Capacity_Target_Actual_Value[Modified Value in sec] ),
        Capacity_Target_Actual_Value[Category] = "Actual-Value",
        Capacity_Target_Actual_Value[Attribut] = "Run Time"
    )
RETURN
    ( T - A ) / 60

If you are satisfied with my answer, please mark it as a solution so others can easily find it.

Don't forget to give KUDOS ? to replies that help answer your questions

Subscribe to ExcelFort: Learn Power BI, Power Query and Excel

[Anonymous]

Hi @Fowmy ,

thanks a lot for your help, it works!!!!!!!🤗

I would like to make one more cosmetic change -> format hh:mm:ss for deviation

I tried to put both processing measure in on new measure with a variable, but as result I got the same old failure.

Maybe you have an idea... 😀

Can you explain to me, why power bi calculates wrong, if I just subtract the two measures from each other (Target - Actual) ?

I would like to understand better Power bi.

Anyway, thank you very much for your help!!

freiburgc

[Fowmy]

@Anonymous 

Great!

In your Actual and Target measure, the seconds are converted to HH: MM: SS, when you subtract, the result can not depend on the converted values as they are not seconds anymore, hence, I brought it back to seconds and did the subtraction. I am not sure if the formatting of the Variance measure is possible, let try when time permits.

If you are satisfied with my answer, please mark it as a solution so others can easily find it.

Don't forget to give KUDOS 👍 to replies that help answer your questions

Subscribe to ExcelFort: Learn Power BI, Power Query, and Excel

[Anonymous]

Hi @v-juanli-msft ,

thank you for offering me your help!

I think have solved my previous problem, hopefully! 😅

But unfortunatley I have another problem, where you might could help me with.

The following picture shows a production job with production steps.

The first column shows the planed time for every production step and the second column the actual time which was needed. third column shows the deviation of the first and second column. the last one is the produced quantity.

I don´t understand whay in the yellow marked line deviation is so wrong.

All these measure are based on seconds and transformed to hh:mm:ss with measure of Chelsie Eiden´s Duration formula.

I would like to upload the data, but i have to admit, I don´t know how. I can export the based data for the screen shot. But I don´t how to share it with.

Thank you for your help!

freiburgc

[Fowmy]

Hi,

What is the calculation (Measure), please share?