Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi guys,
I am hoping you can help as I am going in circles.
I am looking to calculate the stdev for a [data] column, grouped according to a [VarFtrID] column and then a [Sequence] column.
If I put a Card on the Report page how can I get it to display the stddev correctly? I can use a slicer to select the correct [VarFtrID] but then my data is sometimes subgrouped, where the same [Sequence] number will be repeated throughout the subgroup.
Any help greatly appreciated.
Solved! Go to Solution.
Hi @PhilipH ,
I created some data:
Here are the steps you can follow:
1. Create calculated column.
The standard deviation of the entire population
the standard deviation of the entire population =
CALCULATE(STDEV.P('Table'[data]),FILTER(ALL('Table'),'Table'[VarFtrID]=EARLIER('Table'[VarFtrID])&&'Table'[Sequence]=EARLIER('Table'[Sequence])))
Refer to :
STDEV.P function (DAX) - DAX | Microsoft Docs
The standard deviation of a sample population
the standard deviation of a sample population. = CALCULATE(STDEV.S('Table'[data]),FILTER(ALL('Table'),'Table'[VarFtrID]=EARLIER('Table'[VarFtrID])&&'Table'[Sequence]=EARLIER('Table'[Sequence])))
Refer to :
STDEV.S function (DAX) - DAX | Microsoft Docs
2. Result:
Best Regards,
Liu Yang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly
Hi @PhilipH ,
I created some data:
Here are the steps you can follow:
1. Create calculated column.
The standard deviation of the entire population
the standard deviation of the entire population =
CALCULATE(STDEV.P('Table'[data]),FILTER(ALL('Table'),'Table'[VarFtrID]=EARLIER('Table'[VarFtrID])&&'Table'[Sequence]=EARLIER('Table'[Sequence])))
Refer to :
STDEV.P function (DAX) - DAX | Microsoft Docs
The standard deviation of a sample population
the standard deviation of a sample population. = CALCULATE(STDEV.S('Table'[data]),FILTER(ALL('Table'),'Table'[VarFtrID]=EARLIER('Table'[VarFtrID])&&'Table'[Sequence]=EARLIER('Table'[Sequence])))
Refer to :
STDEV.S function (DAX) - DAX | Microsoft Docs
2. Result:
Best Regards,
Liu Yang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly
User | Count |
---|---|
124 | |
108 | |
99 | |
62 | |
62 |
User | Count |
---|---|
137 | |
115 | |
102 | |
71 | |
61 |