topic Calculate Coefficient of Variation for Category in DAX Commands and Tips

Calculate Coefficient of Variation for Category

SalmanABDul_97 — Tue, 15 Mar 2022 06:45:42 GMT

Hi everyone,

you have been very Helpfull to me and i really appreaciate that.

I'm trying to calculate the Coefficent of variance for different Product name. I have 300 Product name

and their Selling Price. Also I will apply outside filter for Regions.

I used the Quick measure in power bi

Vari = VARX.P(KEEPFILTERS(VALUES('TABLE'[Product NAME])), CALCULATE [ Selling Price]))

Selling Price is Calculated measure.

but the result was 0.00 for all the products. i'm not sure where is the problem ?

Re: Calculate Coefficient of Variation for Category

Anonymous — Tue, 15 Mar 2022 16:24:00 GMT

Hi SalmanABDul_97 , the DAX syntax does not look correct. "Keepfilters(Value('Table'[Product Name]))" will be a table containing one column with Product Names, it will not contain the Selling Price. "Calculate ( [Selling Price] )" would not be correct because it is expecting a column not a measure.

Please consider the following VARX.P - DAX Guide for more information.

It is possible that you need to create a table Variable like this.

CoV = 
 VAR _temp = SUMMARIZE ( Table, Table[Product Name] )
 VAR _add = ADDCOLUMNS ( _Temp, "Add Selling Price" , [Selling Price] )
  RETURN
VARX.P( _add, [Add Selling Price] )

Re: Calculate Coefficient of Variation for Category

SalmanABDul_97 — Wed, 16 Mar 2022 08:23:49 GMT

I used this dax function for calculating STD

STD = Calculate(STDEVX.P('fact table', [Value]) , ALLSELECTED () )

the issue with this is it give me wrong std , greater than mean.

same dax i used to find CV but its give me high cv number >100

and problem is beacuse it calculate std wrong.

i need it dynamic whenever i change out filter it should change so i used ALLSELECTD

Re: Calculate Coefficient of Variation for Category

Anonymous — Wed, 16 Mar 2022 08:36:39 GMT

Hi SalmanABDul_97 - it difficult to comment with access to the underlying data model, but I am not sure why or if you need CALCULATE to change the filter context. It might help to read the following blog on ALLSELECTED to understand what is happening in the background. The definitive guide to ALLSELECTED - SQLBI

Re: Calculate Coefficient of Variation for Category

v-angzheng-msft — Thu, 07 Apr 2022 10:28:05 GMT

Hi, SalmanABDul_97

May I ask if your problem has been solved? Is the above post helpful to you?

Could you please consider sharing more details about it and posting expected result so it is clear on what needs to be implemented? And It would be great if there is a sample file without any sesentive information here.

It makes it easier to give you a solution.

Sample (dummy dataset) data as text, use the table tool in the editing bar
Expected output from sample data
Explanation in words of how to get from 1. to 2.

Best Regards,
Community Support Team _ Zeon Zheng

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.