The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends September 15. Request your voucher.
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.
Solved! Go to Solution.
@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 , 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.
User | Count |
---|---|
14 | |
12 | |
7 | |
6 | |
5 |
User | Count |
---|---|
28 | |
19 | |
13 | |
7 | |
5 |