Standard Deviation of calculate column

[maxhrc]

Hi, need help to calculate STDV.P in DAX of a calculate column "errore".

I can't make STDEV.P(Data[errore]) because PowerBi not see column "errore" as column data.

This is code about "errore"

errore =

VAR tbl = ADDCOLUMNS( SUMMARIZE( ALL(Data), Data[Data] ), "@val1", [SOT 1], "@val2", [SOT 2] )

VAR tbl_fil = FILTER( tbl, AND( NOT ISBLANK( [@val1] ), NOT ISBLANK( [@val2] ) ) )

VAR result = [SOT 2]-[previsto]

RETURN result

Excuse me....I'm nOOb 🙂

[HotChilli]

[maxhrc]

Excuse me sir, I send the wrong file.

This is good

https://we.tl/t-pIxM3wIRKg

[HotChilli]

I have the file, thank you.

What are we trying to work out the standard deviation of? The previsto and error measures are missing from the pbix

[maxhrc]

If u select the table and check previsto and errore in "data" on the right there appear.

I need Standard dev of all value present in the errore column.

[HotChilli]

Thanks for the picture.  It looks like previsto, errore, pendenza, intercetta are all measures (so not calculated columns - it does matter)  Maybe we are having some translation issues.

--

If you post a small data sample (not a picture) and show the desired result (i know you want a std deviation but if you can be more detailed i.e. the explicit result then I can try and have a look.

Maybe you can post a link to the pbix (after removing sensitive data)

[maxhrc]

Yes, of course, excuse missunderstanding, my english is not very well... 😬 Yes are measures....

I need a simple standard deviation of column "errore". I make thsi work on excel, but need to translate on PowerBi, on Excel I put this formula: =DEV.ST.C(Tabella_SP_RUS[ERRORE])

It's a one number value, on Excel result is: 117,71 circa

here my file: https://we.tl/t-BDPVJRA5kV

[HotChilli]

This is a calculated column, yes?  But the picture here looks like a table visual.  What does it look like in data view?

--

The variable  - VAR tbl_fil - is unused.

What are previsto, SOT1 and SOT2?

--

If you post a small data sample and show the desired result, that would help

[maxhrc]

SOT1 and SOT2 are data from excel file. previsto, errore, pendenza, intercetta are calculate value from SOT1 and SOT2

I Need calculate a standard dev of alla value from "errore"