Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Logic Issue (Added raw data for context)

Hi Folks,   I have 2 fields: Manager Name & Employee Type in which I need to use as criteria for a formula. What I want to do is create a measure or calculated column in a table visual that looks a...
Need Help
v-danhe-msft's avatar
v-danhe-msft
Microsoft Employee
8 years ago

Hi Anonymous,

Based on my test, you could refer to below steps:

Copy your row table and use the group by function.

 

 

Apply it and create a calculated column.

Type = IF([a]="Contractor"&&[b]="Contractor","Contractors Only",
IF([a]="Employee"&&[b]="Employee","Employees Only","Employees & Contractors"
))

Now you can see the result.

You can also download the PBIX file to have a view.

https://www.dropbox.com/s/lg8q8nd276u6yoo/Logic%20Issue%20%28Added%20raw%20data%20for%20context%29.pbix?dl=0

 

Regards,

Daniel He

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    Hi v-danhe-msft,

     

    Thank you for this. Unfortunately, I cannot seem to do that as "Employee Type" is a group I used to roll the 7 different types of people into two buckets. I tried doing it as a calculated column, but wouldn't show up on field list. 

     

    Is there an alternate way?