Forum Discussion

walker8888's avatar
walker8888
Icon for Helper II rankHelper II
4 years ago

Clustered Bar chart 100%

Ihave a chart that has both Internal and External FTE's %. I want both to equal to a total of 100% but seperately. Instead they both combined equal to 100%. How do I get the result I want? Thanks in advance!

 

Need Help

2 Replies

  • amitchandak's avatar
    amitchandak
    Icon for Super User rankSuper User
    4 years ago

    walker8888 ,

    Create a measure like

     

    divide([Measure], calculate([Measure], filter(allselected(Table), Table[fte] = max(Table[fte]) ) ) )

    • walker8888's avatar
      walker8888
      Icon for Helper II rankHelper II
      4 years ago

      I have never written a measure so I am a bit confused on where to put what