Divide filtered value between not filtered value

[jddaa]

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?
 

 
Thank you all !

[v-shex-msft · Accepted solution]

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

[jddaa]

Thank you very mucho, solved!

[Ashish_Mathur]

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.