How to sum up values using If when the value is splitted into two rows

[Nishanthi]

In the below scenario, if Jan month has fcst and actual , then only "Actual" has to be considered. If there's no entry for actual then "Fcst" has to be considered.

Sample data:

Project id	Month	Budget Type	Amount
123	Jan	Fcst	10,000
123	Jan	Actual	5,000
999	Jan	Fcst	12,000
658	Jan	Fcst	30,000
658	Jan	Actual	30,000

[edwin]

a simple expression would be:
if(count({<[Budget Type]={'Actual'}>}[Budget Type])>0, sum({<[Budget Type]={'Actual'}>}Amount), sum({<[Budget Type]={'Fcst'}>}Amount))

which translates to if there is at least 1 count of Budget type=actual for the product, use actual else use forecast
this assumes that you will use Product at least as dimension

[Nishanthi]

Thanks Edwin. But any chance to pull in the backend ?