Forum Discussion

B_Ed1978's avatar
B_Ed1978
New Member
2 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
    2 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:

     

danextian's avatar
danextian
Super User
2 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:

 

  • B_Ed1978's avatar
    B_Ed1978
    New Member
    2 years ago

    Many thanks this is great