Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
I have already performed the measurements on the table and receiving the incorrect results of the grand total. So how can I do to change the result to the correct information?
Every column is showing the grand total calculated from a measure. Terminal logon is only one from my table.
Please help me!!!!
Thank you all.
Solved! Go to Solution.
HI @saranp780
Try adding this MEASURE
New Save_User = IF ( HASONEFILTER ( Table1[UserName] ), [Save user], SUMX ( ALLSELECTED ( Table1[UserName] ), [Save user] ) )
HI @saranp780
Try adding this MEASURE
New Save_User = IF ( HASONEFILTER ( Table1[UserName] ), [Save user], SUMX ( ALLSELECTED ( Table1[UserName] ), [Save user] ) )
User | Count |
---|---|
102 | |
90 | |
80 | |
71 | |
70 |
User | Count |
---|---|
114 | |
99 | |
97 | |
73 | |
72 |