Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
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...
Need Help
  • Anonymous's avatar
    Anonymous
    7 years ago

    Hi Lin, Awesome this work fine thanks !!

Anonymous's avatar
Anonymous
Not applicable
7 years ago

I have a pbix file with what you might be needing, let me know if this works:

 

https://files.fm/u/mevqpbu8

RakeshBI's avatar
RakeshBI
New Member
7 years ago

Hi Nikhil, 

 

Thanks for shring file but issue is reamin same.... You calculate Bonuspct and Yes/NO calculation in column but we need to do these calculation in measure because so that I can use these calculation in other way as well not only employee wise.

 

We need to do that in meausre and then we need to count Yes/No  measure on the basis of dep.

 

 

    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago

      Nikil, you are refring Yes/No and bonuspct in nocount and yescount measure but in my case yes/no and bonuspct also calculted in measure that is the issue. 

      • v-lili6-msft's avatar
        v-lili6-msft
        Icon for Community Support rankCommunity Support
        7 years ago

        hi, Anonymous

        After my research, you may try to this way as below:

        Step1:

        Add two count measure

        Yes = var _table=ADDCOLUMNS(Ref,"Yes/No",[Yes/No]) return
CALCULATE(COUNTROWS(FILTER(_table,[Yes/No]="Yes")))


No = var _table=ADDCOLUMNS(Ref,"Yes/No",[Yes/No]) return
CALCULATE(COUNTROWS(FILTER(_table,[Yes/No]="No")))

        Step2:

        Drag dep field and these two measure into table visual

         

        here is pbix, please try it.

        https://www.dropbox.com/s/emxxhz3n2mpck3f/how%20to%20count%20measure%20value.pbix?dl=0

         

        Best regards

        Lin