Calculation query

[Anonymous]

Hello community,

I need help with the following query:

I need to calculate the count of ID where, if Directors is less than 5 then add it into managers. That is as shown below image manager's count should be 6.

Thanks in advance.

Regards

[jppv20]

Hi @Anonymous ,

This should work.

Add a new column in your table:

Team Level 2 = IF('Table'[Team Level]="Directors","Managers",'Table'[Team Level])

Create a new table:

Create two relationships between the tables:

Then create this measure:

Measure = IF(CALCULATE(COUNT('Table'[ID]),'Table'[Team Level]="Directors")<5,CALCULATE(COUNT('Table'[ID]),USERELATIONSHIP('Team Level'[Team Level],'Table'[Team Level 2])),CALCULATE(COUNT('Table'[ID])))

This will give the following result:

Jori

If I answered your question, please mark it as a solution to help other members find it more quickly.

[Anonymous]

Thank you for the solution. Works for me 👍

Really appreciate it!

[jppv20 · Accepted solution]

Hi @Anonymous ,

Can you provide some example data from your table?

Jori

[Anonymous]

Here is the sample data: