Forum Discussion

refint650's avatar
refint650
Icon for Helper III rankHelper III
4 years ago
Solved

distinct employee count Less than threshold value

Hello  My requriment  to show count of employees whose variance amount less than $1M ,so to achieve this i'm doing calculations of actuals & forceast, variance in 3 measure columns.  so in return fu...
General Comment
Need Help
Show and Tell
Tips and Tricks
  • TheoC's avatar
    TheoC
    4 years ago

    Hi refint650 

     

    You can achieve this using following measure:

     

    Measure = CALCULATE ( DISTINCTCOUNT ( 'Table'[Employee Name] ) , FILTER ( 'Table' , 'Table'[Amount] < 1 ) )

     

    Hope this helps!

    Theo 🙂

     

  • v-zhangti's avatar
    v-zhangti
    4 years ago

    Hi, refint650 

     

    When Actuals, Forecast, and Variance are all Measure, you can also try the following methods.

    Measure =
IF (
    [Measure Variance] < 1,
    CALCULATE (
        DISTINCTCOUNT ( 'Table'[Name] ),
        FILTER ( ALL ( 'Table' ), [Measure Variance] < 1 )
    ),
    0
)

     

    Best Regards,

    Community Support Team _Charlotte

    If this post helps, then please consider Accept it as the solution to help the other members find it more.

TheoC's avatar
TheoC
Icon for Community Champion rankCommunity Champion
4 years ago

Hi @refint650 

 

You can achieve this using following measure:

 

Measure = CALCULATE ( DISTINCTCOUNT ( 'Table'[Employee Name] ) , FILTER ( 'Table' , 'Table'[Amount] < 1 ) )

 

Hope this helps!

Theo