Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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?
Solved! Go to 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
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
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
98 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
100 | |
86 | |
64 |