Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Total Value Columm Measure

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?
 
Need Help
Show and Tell
Tips and Tricks
  • AlB's avatar
    AlB
    6 years ago

    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  Datanaut

     

4 Replies

  • AlB's avatar
    AlB
    Icon for Community Champion rankCommunity Champion
    6 years ago

    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  Datanaut

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      thanks!

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      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's avatar
        AlB
        Icon for Community Champion rankCommunity Champion
        6 years ago

        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  Datanaut