Exclude Users from Ranking RANKX
Jolly Day, I am needing to exclude three users from being included in the ranking. What I currently have just inserts a dash where there ranking number would be and are still being ranked. Could someone help me with a measure to completely exclude them? Entry Rank = IF(SELECTEDVALUE (System_Users[Account]) IN {"cbelcher","pkessell","kcole"}, "-", RANKX(ALL(System_Users),Audit[Sum Entry]) ) Many thanks in advance!Want measures to exclude calculation when date doesn't exist.
Completed hold stage for the top three rows hasn't got a completion date populated yet and it's defaulted to 44798.00 All the rows under this dont have a completion date for complaint actionable and it's doing the same thing. I want the DAX to give today's date if there is no completion date populated but only if the action EXISTS. I'm trying to get this to show the amount of time for each measure in days. Here are the two measures: Completed Holding stage age = VAR startdate = MAXX(FILTER('hgmcntac', hgmcntac[action_cd] = "C1001A"), hgmcntac[completed_dt]) VAR enddate = MAXX(FILTER('hgmcntac', hgmcntac[action_cd] = "C1002"), hgmcntac[completed_dt]) RETURN ROUNDUP((enddate - startdate) * 1,0) Complaint actionable = VAR enddate = MAXX(FILTER('hgmcntac', hgmcntac[action_cd] = "C1001A"), hgmcntac[completed_dt]) VAR startdate = MAX(hgmcntct[taken_by_dt]) RETURN ROUNDUP((enddate - startdate) * 1,0) Thanks in advance, Dan
How to exlude SUM of zero
Hi, Here is a measure SUM (0+0+0+0.6+0.6+0.6...) divided by COUNT of dates. The question is how to exclude those dates when summary equals 0.00 from this calculations? Currently it calculates: 4.2 / 12 = 0.35 I need it to calculate: 4.2 / 7 = 0.6 the reason 0.00 is showing for some dates is because in the data there is 0.6 but later on there was another data added with -0.6 for those dates. Hence below we see the summary. Thank you!
