Forum Discussion

nmaddock's avatar
nmaddock
Icon for Helper I rankHelper I
7 years ago
Solved

DAX calculation in a different context

Hi,   Im trying to calculate Kg's per M3 for industry types based on all the jobs we have already done and then use this value in a report in a different context. i'e' in the context of a service a...
Need Help
  • jdbuchanan71's avatar
    jdbuchanan71
    7 years ago

    Hello nmaddock 

    You can use ALLSELECTED over your table to achieve your goal.

    KG's Per M3 = 
IF ( NOT ISBLANK ( [Total Weight] ),
    CALCULATE(
        DIVIDE([Total Weight], 
        DIVIDE([Total Volume],1000))  
        ,ALLSELECTED(Agreement)
    )
)

jdbuchanan71's avatar
jdbuchanan71
Icon for Super User rankSuper User
7 years ago

Hello nmaddock 

You can use ALLSELECTED over your table to achieve your goal.

KG's Per M3 = 
IF ( NOT ISBLANK ( [Total Weight] ),
    CALCULATE(
        DIVIDE([Total Weight], 
        DIVIDE([Total Volume],1000))  
        ,ALLSELECTED(Agreement)
    )
)

nmaddock's avatar
nmaddock
Icon for Helper I rankHelper I
7 years ago

That worked perfect, thank you :-) its easy when you know how