Forum Discussion
harshagraj
Post Partisan
Post PartisanTo Filter out null and 0
Hi all i have 3 columns USER_DN, Manager Expectation,Final Rating and i have a measure % gap. Now i have to differenciate User DN based on gap % if % gap>=0 then "Met", "Not Met" But I would need t...
harshagrajPost Partisan
Post PartisanThank you parry2k But i want to display Met-Distinctcount & Not Met-Distinctcountof UserDN by excluding nulls and zeros in Manager Expectation and Final Rating. The calculation is getting effected because of nulls and 0. The calcuation i used for % gap is
(AVERAGE('USER_RATING'[Final_User_Rating])/AVERAGE('USER_RATING'[MANAGER_EXPECTATIONS]))-1.
I can exclude nulls and 0 in query level but other calculations will be effected. I tried something like below but i didnt work.
Met_Not Met =
CALCULATE (
IF ( [% gap] >= 0, "Met", "Not Met" ),
FILTER (
'SA USER_RATING',
NOT ( ISBLANK ( 'SA USER_RATING'[Final_User_Rating] ) )
&& 'SA USER_RATING'[Final_User_Rating] <> 0
&& NOT ( ISBLANK ( 'SA USER_RATING'[MANAGER_EXPECTATIONS] ) )
&& 'SA USER_RATING'[MANAGER_EXPECTATIONS] <> 0
)
)
parry2k
Super User
Super Userharshagraj did you tried what I suggested? If it didn't worked then explain what is not working and what is your expected output. Read this post to get your answer quickly.
https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490