Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Compete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.

Reply
Anonymous
Not applicable

applying all function only for a value within a measure

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?

3 REPLIES 3
v-ljerr-msft
Microsoft Employee
Microsoft Employee

@Anonymous


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

Anonymous
Not applicable

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

Anonymous
Not applicable

QlikView expression that works with this expression: ((sum (Vl_Receita) - sum (Vl_Estorno)) * 100) / sum ({$ <Month =>} Vl_ReceitaPrevista)

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.

Top Solution Authors