After using ROUND function the average value not showing perfectly.

[arifulice09]

I have two simple measure, please see below , when I am using this measures in two matrix then the value is not matching , it is alright for single week, but when selecting multiple week then the problem is showing.(i.e. the following matrix is for two different week)

AvgStaffAtten =ROUND( DIVIDE(DISTINCTCOUNT(JC[Day_NeiBuld_Wk_Usr]),[DistinctWeek]),0)   // Measure1

staffAtt = DISTINCTCOUNT(JC[Day_NeiBuld_Wk_Usr])  // Measure 2

[tamerj1 · Accepted solution]

Hi @arifulice09 

please try

AvgStaffAtten =

SUMX (

SUMMARIZE ( JC, JC[Department], JC[Week Day] ),

CALCULATE (

ROUND( DIVIDE(DISTINCTCOUNT(JC[Day_NeiBuld_Wk_Usr]),[DistinctWeek]),0)   // Measure1

) )

[arifulice09 · Accepted solution]

@tamerj1 Thanks a lot , yes it is working fine....

[tamerj1 · Accepted solution]

Hi @arifulice09 

please try

AvgStaffAtten =

SUMX (

SUMMARIZE ( JC, JC[Department], JC[Week Day] ),

CALCULATE (

ROUND( DIVIDE(DISTINCTCOUNT(JC[Day_NeiBuld_Wk_Usr]),[DistinctWeek]),0)   // Measure1

) )