Forum Discussion

Hudg16's avatar
Hudg16
Icon for Helper I rankHelper I
4 years ago
Solved

Dividing row by column total

I have the column "# Flex Usage" measure and want to get a % of the total for these. For example, in the last row, I want to see 9/130. How can I do this?   
Need Help
  • v-kelly-msft's avatar
    v-kelly-msft
    4 years ago

    Hi  Hudg16 ,

     

    Create a measure as below:

    Measure = 
var _total=CALCULATE(SUM('Table'[Value]),FILTER(ALLSELECTED('Table'),'Table'[Name]=MAX('Table'[Name])))
Return
DIVIDE(SUM('Table'[Value]),_total)

    And you will see:

    For the related .pbix file,pls see attached.

     

    Best Regards,
    Kelly

    Did I answer your question? Mark my reply as a solution!

v-kelly-msft's avatar
v-kelly-msft
Icon for Community Support rankCommunity Support
4 years ago

Hi  Hudg16 ,

 

Create a measure as below:

Measure = 
var _total=CALCULATE(SUM('Table'[Value]),FILTER(ALLSELECTED('Table'),'Table'[Name]=MAX('Table'[Name])))
Return
DIVIDE(SUM('Table'[Value]),_total)

And you will see:

For the related .pbix file,pls see attached.

 

Best Regards,
Kelly

Did I answer your question? Mark my reply as a solution!