Forum Discussion
Solved
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]),FILTER('KBSYS PATCH','KBSYS PATCH'[IS_SUPERCEDED] = false))
Both Measures are the same. The right Measure was created directly in 'KBSYS PATCH' and gives the right amount out, but the left one was created in my measure table and i cant see why it is that way.
May someone tell me, shoud be an easy fix but i cant find something online.
Both Measures are the same. The right Measure was created directly in 'KBSYS PATCH' and gives the right amount out, but the left one was created in my measure table and i cant see why it is that way.
May someone tell me, shoud be an easy fix but i cant find something online.
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
2 Replies
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
Well... that worked. Sorry for wasting your time.
