Total Value Columm Measure

[Anonymous]

Hi
wanna have a measure that allows to calculate the number of "points" u win if your percentage is in a specific range for example for week 35 my percentage is 71%, this number is beetween -9 and 1 so i won 0 points. Also, my Total should give the summ of points won so far

i accomplished the first part by using this measure:

 CALCULATE(VALUES(Scorecard[Puntos]),FILTER(Scorecard,[SalyTo19]>=Scorecard[Desde]&&[SalyTo19]<Scorecard[Hasta]))

however the GrandTotal is not giving me the right number so after reading a lot of similar posts i tryed to use this other measure:

IF(HASONEFILTER(Table1[Week]),

CALCULATE(VALUES(Scorecard[Puntos]),FILTER(Scorecard,[SalyTo19]>=Scorecard[Desde]&&[SalyTo19]<Scorecard[Hasta])),

SUMX(Table1,(VALUES(Scorecard[Puntos]))

but no luck so far

can anyone help me with this?

[AlB · Accepted solution]

Hi @Anonymous 

AssumingTable1[Semana] is what you have in the rows of the visual shown:

Measure =
SUMX (
    DISTINCT ( Table1[Semana] ),
    CALCULATE (
        VALUES ( Scorecard[Puntos] ),
        FILTER (
            Scorecard,
            [SalyTo19] >= Scorecard[Desde] && [SalyTo19] < Scorecard[Hasta]
        )
    )
)

Please mark the question solved when done and consider giving kudos if posts are helpful.

Cheers  

[Anonymous]

@AlB  hi, i just added the Month Row, so now i have Month and week but the month is not adding the amounts of each week subtotal,

any ideas?

[AlB]

You need to add the month in the measure too:

Measure =
SUMX (
    SUMMARIZE ( Table1,Table1[Month], Table1[Semana] ),
    CALCULATE (
        VALUES ( Scorecard[Puntos] ),
        FILTER (
            Scorecard,
            [SalyTo19] >= Scorecard[Desde] && [SalyTo19] < Scorecard[Hasta]
        )
    )
)

Please mark the question solved when done and consider giving kudos if posts are helpful.

Cheers  

[Anonymous]

thanks!