Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Divide filtered value by (non filtered) total

Hello,   I need help in something that might be simple. I have a table with "total transactions per hour" in one column and "50% of the transactions per hour" in another column, something similar ...
Need Help
Show and Tell
  • ChrisMendoza's avatar
    ChrisMendoza
    7 years ago

    Anonymous -

    You should be apple to add another column as:

    % =
DIVIDE ( TableName[50%], SUM ( TableName[TOT] ), 0 )

  • v-chuncz-msft's avatar
    v-chuncz-msft
    7 years ago

    Anonymous 

     

    You may add the measure below.

    Measure 2 =
DIVIDE (
    [50%],
    CALCULATE ( SUM ( 'Table'[TOT] ), ALLSELECTED ( 'Table'[HOUR] ) )
)
ChrisMendoza's avatar
ChrisMendoza
Icon for Resident Rockstar rankResident Rockstar
7 years ago

Anonymous -

You should be apple to add another column as:

% =
DIVIDE ( TableName[50%], SUM ( TableName[TOT] ), 0 )

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    thanks.

    but the challenge is that the "50% transactions" is not a straight calculation from "tot transactions", but the result of SELECTEDVALUE from a filter...

    • v-chuncz-msft's avatar
      v-chuncz-msft
      Icon for Community Support rankCommunity Support
      7 years ago

      Anonymous 

       

      You may add the measure below.

      Measure 2 =
DIVIDE (
    [50%],
    CALCULATE ( SUM ( 'Table'[TOT] ), ALLSELECTED ( 'Table'[HOUR] ) )
)
      • Anonymous's avatar
        Anonymous
        Not applicable
        7 years ago

        thanks a lot  , this is exactly what i was looking for!