Forum Discussion

Yrstruly2021's avatar
Yrstruly2021
Icon for Helper V rankHelper V
2 years ago
Solved

Adding a Fix value to a calculation.

I am trying to add a fixed value "Interco capital returned" 678 to a dax total calculation. To get the fix value i used New CombinedAmount3 =  VAR SelectedCashFlowDescription = SELECTEDVALUE...
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi Yrstruly2021 ,

    Did the above suggestions help with your scenario? if that is the case, you can consider Kudo or Accept the helpful suggestions to help others who faced similar requirements.

    If these also don't help, please share more detailed information and description to help us clarify your scenario to test.

    How to Get Your Question Answered Quickly 

    Regards,

    Xiaoxin Sheng

Dangar332's avatar
Dangar332
Icon for Resident Rockstar rankResident Rockstar
2 years ago

hi, Yrstruly2021 

as i understood your problem you wanna try to get total as fixed value

 

see below as data 

 

same problem like you total= 300 but actual is 5200

but implement measure 3 as below

Measure 3 = 
IF(
    ISINSCOPE('Table'[product]),
    MIN('Table'[value]),
    CALCULATE(sum('Table'[value]),ALL())
)