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.
I have the following measure:
% Target Revenue Monitoring = CALCULATE (IF (ISBLANK ((SUM (Facts [Vl_Receita]) - SUM (Facts [Vl_Estorno])) * 100) / sum (Facts [Vl_ReceitaPrevista]); 0; ((SUM (Facts [Vl_Receita] ) - sUM (Facts [Vl_Estorno])) * 100) / (sum (Facts [Vl_ReceitaPrevista]), ALL (DMEGF_Mes [Month]))) / 100
her goal is to present the percentage of my planned and precise recipe for the value Facts [Vl_ReceitaPrevista] month filter to is not valid but only for that value, ie I want the all function (ALL (DMEGF_Mes [Month]) it is only applied to facts [Vl_ReceitaPrevista] inside my far
How can I do this?
her goal is to present the percentage of my planned and precise recipe for the value Facts [Vl_ReceitaPrevista] month filter to is not valid but only for that value, ie I want the all function (ALL (DMEGF_Mes [Month]) it is only applied to facts [Vl_ReceitaPrevista] inside my far
How can I do this?
Please try the formula below:
% Target Revenue Monitoring = IF ( ISBLANK ( ( SUM ( Facts[Vl_Receita] ) - SUM ( Facts[Vl_Estorno] ) ) * 100 / CALCULATE ( SUM ( Facts[Vl_ReceitaPrevista] ), ALL ( DMEGF_Mes[Month] ) ) ), 0, ( SUM ( Facts[Vl_Receita] ) - SUM ( Facts[Vl_Estorno] ) ) * 100 / CALCULATE ( SUM ( Facts[Vl_ReceitaPrevista] ), ALL ( DMEGF_Mes[Month] ) ) ) / 100
Regards
thanks for the help, I managed to solve the problem, to the field that needed the all () I created a measure only to him and added this measure in my expression and it worked the way I wanted
QlikView expression that works with this expression: ((sum (Vl_Receita) - sum (Vl_Estorno)) * 100) / sum ({$ <Month =>} Vl_ReceitaPrevista)
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 |
---|---|
110 | |
94 | |
80 | |
66 | |
58 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |