Forum Discussion
Calculate measure (standard deviation) based on selection
Hi Anonymous ,
>>I mean, it is a general problem for me to calculate something based on what there is shown in the power bi matrix.
In this scenario, we will need to use the measure rather than a calculated column, a calculated column will be calculated on whole data, the filter will not change it.
We can create a measure using the following DAX query:
STDEV1 = CALCULATE(STDEV.P(Tabelle1[Revenue]),FILTER(ALL(Tabelle1),Tabelle1[Country] = MIN(Tabelle1[Country]) && Tabelle1[Distinct Monat] in ALLSELECTED(Tabelle1[Distinct Monat])))
The result will like below:
Best Regards,
Teige
Solution SageHi Anonymous ,
>>I mean, it is a general problem for me to calculate something based on what there is shown in the power bi matrix.
In this scenario, we will need to use the measure rather than a calculated column, a calculated column will be calculated on whole data, the filter will not change it.
We can create a measure using the following DAX query:
STDEV1 = CALCULATE(STDEV.P(Tabelle1[Revenue]),FILTER(ALL(Tabelle1),Tabelle1[Country] = MIN(Tabelle1[Country]) && Tabelle1[Distinct Monat] in ALLSELECTED(Tabelle1[Distinct Monat])))
The result will like below:
Best Regards,
Teige
Hi TeigeGao,
checking this post, I think have similar issue when it comes to add a standard deviation as a measure.
I have a pivot table with data coming from my data model, showing following data:
- Week numbers in columns [weeknum]
- Product ID in rows [Producto]
- Quantity consumed as Σ [Cantidad]
Point is, a lot of products have zero consumption along the year.
Here comes a screenshoot (week numbers reduced for pasting smaller picture):
What I want is to add a measure showing the total standard deviation as a column at the end based on column selection (eventually will be 52 weeks).
Can you advise?
Thanks,