Help with context filtering

[B_Ed1978]

Hi Power BI experts, I am hoping somone can help. I am trying to write a DAX expression to so I can use a value as a denominater in a further calculation. See screen shot below I am trying to get the values in column A to appear under the heading "PIN" so I could then do a calculation like 

PIN | ADRG Units MAT TY 13,523,924 - PROP | ADRG Units MAT TY and all other filtering is repsected. 

I am sure there is a way, it is just beyond my current skill set

[danextian · Accepted solution]

Hi @B_Ed1978 ,

Try this:

=
CALCULATE (
    SUM ( 'Table'[Units] ),
    ALL ( 'Table'[PIN/PROP] ),
    'Table'[PIN/PROP] = "prop"
)
    - SUM ( 'Table'[Units] )

You will see results similar to below:

[B_Ed1978]

Many thanks this is great

[amitchandak]

@B_Ed1978 , If I create a measure

Calculate([Measure], [column] ="A")

Column ="A" values will appear under all column values when that has been used in visual