DAX calculation to find out average of count measure by categorywise

[anandsoftweb]

Hello Folks,

I need the DAX calculation for average out the count of each status as below in table

E.g :- Bug Count :- 15 and Avg would be 15/ 7(Total bug status record is 7) = 2.14 so I want to display that into the other column on each bug status 

Thanks,

Anand

[MFelix]

Hi @anandsoftweb,

Try this measure:

Bug status = DIVIDE(SUM(Bugs[Count]),COUNT(Bugs[Date]))

Regards,

MFelix

[anandsoftweb]

@MFelix

Thanks for the reply but I want to keep date column should be there and need to find out the average as per the bug status though it should be repeating in column.

[MFelix]

HI @anandsoftweb,

Try this 

Bug Average =
CALCULATE (
    DIVIDE ( SUM ( Bugs[Count] ), COUNT ( Bugs[Date] ) ),
    ALLEXCEPT ( Bugs, Bugs[Bugs] )
)

Final resutl below:

Regards,

MFelix

[anandsoftweb]

@MFelix 

Thanks for the solution but only allexcept(Bug,Bug[status]) wont be working need to consider date as well to figure out the desired solution. 

But useful comment 🙂 

Thanks,

Anand 

[MFelix]

Add the date to.the.allexcept.formula