Forum Discussion

yaman123's avatar
yaman123
Post Partisan
5 years ago

New Function Values

Hi,    Is it possible to create two new functions (highlighted in yellow) - H total and L Total.    H Total is a sum of H Staff and H Production L Total is a sum of L Staff and L Production   ...
Need Help
Show and Tell
Tips and Tricks
Fowmy's avatar
Fowmy
Super User
5 years ago

yaman123 

The two new measures that you need.

H Total = 
SUMX(
    VALUES(Table[Function]),
    INT(UPPER(LEFT(Table[Function],1)) = "H") * [Headcount]
) 


L Total = 
SUMX(
    VALUES(Table[Function]),
    INT(UPPER(LEFT(Table[Function],1)) = "L") * [Headcount]
)
yaman123's avatar
yaman123
Post Partisan
5 years ago

Fowmy 

 

Can a new column be created which will show all functions instead of two new measures. I would like the output to be like the example i attached above? 

  • Fowmy's avatar
    Fowmy
    Super User
    5 years ago

    yaman123 

    I suggest you keep them as measures rather than adding them to the table. Yes, you can but you need to add those two lines in your Function column and create a measure to check and conditionally populate the measure.