Process Cycle Time

[Gururajv007]

Dear Experts - Will be great if you could fix the below problem that I am facing now.

I would like to get the AVERAGE of each columns & visuals like below from TableA. Can you please suggest any Dax formula to calculate or any best approch.

Note  : 2 Million rows with different status.

TableA

Status	Process A	Process B	Process C	Process D
Completed	1	2	8	3
Completed	1	8	8	3
Completed	2	3	4	4
Completed	1	6	3	2
Completed	1	7	2	4

[V-lianl-msft]

Hi @Gururajv007 ,

You may need to create 4 measures to display in visual,please try to create measures like below:

M1 = CALCULATE(AVERAGE('Table'[Process A]),ALLSELECTED('Table'))
M2 = CALCULATE(AVERAGE('Table'[Process B]),ALLSELECTED('Table'))
M3 = CALCULATE(AVERAGE('Table'[Process C]),ALLSELECTED('Table'))
M4 = CALCULATE(AVERAGE('Table'[Process D]),ALLSELECTED('Table'))

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

[Gururajv007]

Thanks for your reply. But with the 4 measures I cannot created & show the visual like the below right. Need to show in a single bar.

[Gururajv007]

Thanks for your reply @amitchandak yes, its for all the 4 columns. I tried using the below dax as you suggested & I have modified to add all 4 colums but I could not get.

Tried 1 : averagex(union(Values(Table[Process A]),Values(Table[Process B]),Values(Table[Process C]),Values(Table[Process B])), [Process A])

Tried 2

Average = averagex(union(Values('Table'[ Process A ]),Values(Table[Process B]),Values(Table[Process C]),Values('Table'[Process D])),SUMX('Table','Table'[ Process A ]+'Table'[Process B]+'Table'[Process C]+'Table'[Process D]))

[amitchandak]

@Gururajv007 , for all 4 columns ?

averagex(union(Values(Table[Process A]),Values(Table[Process B]),Values(Table[Process C]),Values(Table[Process B])), [Process A])