Forum Discussion

B_Ed1978's avatar
B_Ed1978
New Member
3 years ago
Solved

Help with context filtering

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

 

 

Need Help
  • danextian's avatar
    danextian
    3 years ago

    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:

     

3 Replies

  • amitchandak's avatar
    amitchandak
    Super User
    3 years ago

    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

  • danextian's avatar
    danextian
    Super User
    3 years ago

    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: