Forum Discussion
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'...
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
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
Thank you very mucho, solved!