Forum Discussion
mamabox22
4 years agoFrequent Visitor
Same Measure, diffrent outcome
Hey guys, i am confused about a measure i did. I did a measure to Count all columns in a table an noticed that i got a wrong output. Measure = CALCULATE(DISTINCTCOUNT('KBSYS PATCH'[ID...
- 4 years ago
mamabox22 , The diff I Can think of as of now is
CALCULATE(DISTINCTCOUNT('KBSYS PATCH'[ID]),FILTER('KBSYS PATCH','KBSYS PATCH'[IS_SUPERCEDED] = false() ))
do you have formula for other measure
amitchandak
4 years agoSuper User
mamabox22 , The diff I Can think of as of now is
CALCULATE(DISTINCTCOUNT('KBSYS PATCH'[ID]),FILTER('KBSYS PATCH','KBSYS PATCH'[IS_SUPERCEDED] = false() ))
do you have formula for other measure
mamabox22
4 years agoFrequent Visitor
Well... that worked. Sorry for wasting your time.