DAX Formula to Count Values and Calculate Standard Deviation on these Counts

[Anonymous]

Hi,

I am trying to calculate standard deviations within groups for the values. Problem is that these values are initially prices, I need the count for the prices, ie, how many price observarions were in certain municipalities, and then apply STDEV on them against average counts of price observations for the region, where the municipalities fall.

I can not seem to get hold on the count values of prices to apply further calculations to them, STDEV or anything.

In Excel this is quite easy, I am attaching the sample file ST DEV on COUNTS with edit permission so that anyone can explore the forumlas, but in Power BI Desktop I was unable to recreate the same result. I am kind of intermediate level user, but still could not make it work.

Your help would be much appreciated.

Best,

Levan

[quentin_vigne]

Hi @Anonymous

If you use CALCULATE(Count(YourTable[Price]);YourTable[MunicipalityName]=MunicipalityName) does it work ? 

- Quentin

[Anonymous]

Also, does not work new calculated column with same formula.

[Anonymous]

eqeq = STDEV.P(_2017[CountSellingPricesCOLUMN])

[Anonymous]

Hi @quentin_vigne,

I used this formula to obtain counts, but then I can't use these values to apply STDEV formula.

CountSellingPrice = CALCULATE(COUNT(_2017[Value]),FILTER(_2017,_2017[Attribute]="Price: Local"),FILTER(_2017,_2017[Value]>0))