Measure to return single number which is the sum of another measure

[liuruby8]

Hi all,

I have a question needs your help! 

I have a time slicer to choose among: current month, last twelve months, and current financial year. The output page will be recalculated based on the timeframe user selected. One of the tables on the output page will show the list of employees whose sale are below the targets. I created a measure to calculate if the employee is under target, it will return 1, otherwise, it will be 0. I want to create another measure to sum the previous measure and put the total number of employees who are below target (the sum of the previous measure) in a card (as the visualisation).

Please note that the card number will also be adjusted based on the timeframe slicer.

Any suggestion will be really appreciated! Thank you a lot and sorry that I cannot share the file as it is confidential and also relatively complex (so it is hard for me to create a simple example with dummy data).

Ruby

[BalaVenuGopal]

Hi @liuruby8 ,

Fom your conversation , You already created mesure so just you drag that measure and realted dimension column as your measure has only 1 and 0 sum will give you count of employess in report.

Please reply if this is not the case

[liuruby8]

Hi - thank you for your reply. However, I tried your method before and it does not work as it is a measure and always show 0 via the card......

thank you anyway 

[BalaVenuGopal]

Hi @liuruby8 ,

You implement your 1 and 0 value logic in calculated column use this column in your measure if this will not work pls give screen short with data and report

[liuruby8 · Accepted solution]

Thank you for your reply. I have solved the issue now and appreciate your time and trying to help!