Measure for a manual adjustment for a specific filter

[svc_powerbi]

Hi, I am working with datas from different branchs. I developped measures to calculate investments for each branch. There is one of them that I need to add a manual amount in the calculation, so I developped a measure like this, where I need to add 2 597798$ to a particular branch "ADT1" :

Ajustement investissement Dix30 = calculate(2597798 ; filter('BI-Branch'; 'BI-Branch'[Branch] = "ADT1" ) ).

When I use this measure in a table to validate, this numbers comes for every branches. Any idea how to solve this?

[v-jiascu-msft · Accepted solution]

Hi @svc_powerbi,

The result is expected. The CALCULATE changes the calculation context of its first parameter. Since it's a const value, nothing is changed. The solution could be as follows.

Ajustement investissement Dix30 =
IF ( MIN ( 'BI-Branch'[Branch] ) = "ADT1", 2597798, BLANK () )

Best Regards,

Dale

[svc_powerbi]

Thank you so much v-jiascu-msft!

One question: why is the MIN necessary? Thanks again! Valerie

[v-jiascu-msft]

Hi @svc_powerbi,

It's my pleasure. 

The column is used in a measure where there isn't a Row Context. In other words, the formula doesn't know which row in the column to compare with. There will be only one value of the column when the measure is evaluated in the visualization. So you still can try it with MAX. 

Best Regards,

Dale