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

     

Anonymous's avatar
Anonymous
Not applicable
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

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    Hi guys!

     

    I've got a similar issue, but in my case the measure doesn't return a binary value, but Text Values (Overdue, On Track, Concluded [for exemple]), and I'd like to display the amount of times those values are appearing on my matrix.

    Btw, i use this measure already on a matrix, and I want to improve this simple dashboard with graphs.