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...
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:

     

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