Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now

Reply
arifulice09
Helper I
Helper I

After using ROUND function the average value not showing perfectly.

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

 

 

Image.PNG

 

 

 

 

2 ACCEPTED SOLUTIONS
tamerj1
Super User
Super User

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

) )

View solution in original post

arifulice09
Helper I
Helper I

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

View solution in original post

2 REPLIES 2
arifulice09
Helper I
Helper I

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

tamerj1
Super User
Super User

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

) )

Helpful resources

Announcements
OCT PBI Update Carousel

Power BI Monthly Update - October 2024

Check out the October 2024 Power BI update to learn about new features.

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

October NL Carousel

Fabric Community Update - October 2024

Find out what's new and trending in the Fabric Community.