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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Anonymous
Not applicable

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

 

tabla.JPGpuntaje.JPG

 

 

 

 

 

 

 

 

 

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?
 
1 ACCEPTED SOLUTION
AlB
Super User
Super User

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

 

View solution in original post

4 REPLIES 4
AlB
Super User
Super User

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
Not applicable

@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?

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

Anonymous
Not applicable

thanks!

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

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