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
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
Solved! Go to 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
) )
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
) )
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
114 | |
109 | |
107 | |
92 | |
68 |
User | Count |
---|---|
167 | |
130 | |
129 | |
94 | |
91 |