Forum Discussion

RakeshBI's avatar
RakeshBI
New Member
7 years ago
Solved

How to count measure value

Hi,    I have Emp_ID, Dept, bonus and salary. I calculated bonus % in a measure and then another measure to with condition Bonus<= 5% then "Yes" else "No".    Now I have Emp_ID, Dept, bonus % and...
  • Anonymous's avatar
    Anonymous
    7 years ago

    RakeshBI,

    Create the following measure in your table and create a table visual as follows. If the DAX doesn't return your expected result, please share sample data of your table and post the DAX you use to calculate bonus % and  Bonus<= 5%

    Measure 2 = CALCULATE(COUNT(Table1[Emp_ID]),FILTER(Table1,Table1[Bonus 5%]="Yes"))



    Regards,
    Lydia

     

Naomig2088's avatar
Naomig2088
Helper II
2 years ago

Hi, 

Can you count mutliple values using one measure? So "yes" and "no" would be counted in the same measure? I need to use the measure to feed into another measure and can't do this if there are mutliples. Thank you.