Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
tananich
Frequent Visitor

Measure returning incorrect value

Hi all,

 

I have a strange issue, could someone please  help me with that.

I have a grid as in the picture below

1.jpg

 

I need to distinct count of employees with "Overreported in column "Test3" (negative value in column 'project gap")

 

I have a measure "Overreported Ppl" =  CALCULATE(Distinctcount ('Table_Name'[Employee]), FILTER( 'Table_Name', 'Table_Name[Project Gap]<0))

However it returns me employees with positive numbers in 'project gap' column and who are marked as  'Underreported' in test3 column.

I cannot figure this out how come I get something like that? Smiley Frustrated

 

Thank you

1 ACCEPTED SOLUTION
v-chuncz-msft
Community Support
Community Support

@tananich,

 

You may try the following measure.

Measure =
COUNTROWS (
    FILTER (
        VALUES ( 'Table_Name'[Employee] ),
        CALCULATE ( SUM ( 'Table_Name'[Project Gap] ) < 0 )
    )
)
Community Support Team _ Sam Zha
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

6 REPLIES 6
tananich
Frequent Visitor

@v-chuncz-msft

thank you, that works!

v-chuncz-msft
Community Support
Community Support

@tananich,

 

You may try the following measure.

Measure =
COUNTROWS (
    FILTER (
        VALUES ( 'Table_Name'[Employee] ),
        CALCULATE ( SUM ( 'Table_Name'[Project Gap] ) < 0 )
    )
)
Community Support Team _ Sam Zha
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
BobBI
Resolver III
Resolver III

Hi  ,

 

you this DAX , this will count emplyee where pr_gap has -ve value.

 



Overreported People = CALCULATE(DISTINCTCOUNT(valueTest[Employee]),
FILTER(valueTest,
SIGN(valueTest[Pr_gap])=-1
)
)

out put.JPG

 

Thanks,

SS

Hi @BobBI

 

Thanks for reply, I used exactly your formula however the same result see below, this is new column called test overrep ppl

 photo_2018-10-30_14-35-51.jpg

Try this

"Overreported Ppl" =  CALCULATE(Distinctcount ('Table_Name'[Employee]), FILTER( All('Table_Name'), 'Table_Name[Project Gap]<0))

if it solve please mark as solved, and give me your positive feedback.

Hi @rafaelmpsantos

thanks for reply, unfortunately that doesn't work, i need to count employees and this formula returns completely different value

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.