Forum Discussion

jddaa's avatar
jddaa
New Member
7 years ago
Solved

Divide filtered value between not filtered value

Hi all!
 
I'm trying to divide two values:
Value A= Calculated value, non filtered. Independent from slicer value.
Value B= Calculated value, same as value A but depending on slicer value.
 
I'd like to show as value C the next operation:
Value B/Value A , but I don't know how to figure out this problem. Someone can help me with this problem?
 
img
 
Thank you all !
Need Help
  • Anonymous's avatar
    Anonymous
    7 years ago

    Hi jddaa,

     

    You can try to use following measure if it suitable for your requirement:

    valueA =
CALCULATE ( SUM ( Table[Amount] ), ALL ( Table ) )

valueB =
CALCULATE ( SUM ( Table[Amount] ), ALLSELECTED ( Table ) )

valueC =
DIVIDE ( valueA, valueB, -1 )

     

    Regards,

    Xiaoxin Sheng

3 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    Hi jddaa,

     

    You can try to use following measure if it suitable for your requirement:

    valueA =
CALCULATE ( SUM ( Table[Amount] ), ALL ( Table ) )

valueB =
CALCULATE ( SUM ( Table[Amount] ), ALLSELECTED ( Table ) )

valueC =
DIVIDE ( valueA, valueB, -1 )

     

    Regards,

    Xiaoxin Sheng

  • Ashish_Mathur's avatar
    Ashish_Mathur
    Super User
    7 years ago

    Hi,

     

    You will have to use the CALCULATE() with the ALL() or ALLEXCEPT().  To get more specific help, share some data and show the expected result.  Share the link from where i can download your PBI file.