How to add braces to a count from 1 column with another using power bi desktop

[ashraparas]

Hello,

I need to concatenate 2 count in 1 field and have the 2nd count into brackets.

For example:

Quarter   Region      Extra work done (0 - No, 1- Yes)

Q2 2024  APAC              0

Q3 2024  AMER             1

Q4 2024  EMEA             1

Q2 2024  APAC              1

Q3 2024  AMER             1 

so my final output should show as a pivot with Region on the rows and count of of work done by quarter on the right plus (extra work done). It basically counts the the number of times region is used in the row plus the count of 1's as the extra work done for that region. Appreciate any help on this please

Region        Q2 2024       Q3 2024         Q4 2024

APAC               0                1(2)                 0

EMEA              2(4)            3(1)                 2(1)

AMER              2(2)            7(4)                 3(0)

[dharmendars007 · Accepted solution]

Hello @ashraparas , 

You can create 2 measure and concatenate the same as one and add it to the Matrix Visual

Measure 1.  Total Count = COUNTROWS('YourTable')

Measure 2.  Extra Work Count = CALCULATE(COUNTROWS('YourTable'), 'YourTable'[Extra work done] = 1)

Concatenated Measure

Concatenated Measure =
VAR Total = [Total Count]
VAR ExtraWork = [Extra Work Count]
RETURN
Total & "(" & ExtraWork & ")"

If you find this helpful , please mark it as solution which will be helpful for others and Your Kudos/Likes 👍 are much appreciated!

Thank You

Dharmendar S

LinkedIN 

[v-xinruzhu-msft · Accepted solution]

Hi @ashraparas 

Did the solution @dharmendars007  offeded help you solve the problm, if it helps, you can consider to accept it as a solution so that more user can refer to.

Best Regards!

Yolo Zhu

[dharmendars007 · Accepted solution]

Hello @ashraparas , 

You can create 2 measure and concatenate the same as one and add it to the Matrix Visual

Measure 1.  Total Count = COUNTROWS('YourTable')

Measure 2.  Extra Work Count = CALCULATE(COUNTROWS('YourTable'), 'YourTable'[Extra work done] = 1)

Concatenated Measure

Concatenated Measure =
VAR Total = [Total Count]
VAR ExtraWork = [Extra Work Count]
RETURN
Total & "(" & ExtraWork & ")"

If you find this helpful , please mark it as solution which will be helpful for others and Your Kudos/Likes 👍 are much appreciated!

Thank You

Dharmendar S

LinkedIN