Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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]),
Solved! Go to 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
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
@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
thanks!
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
65 |
User | Count |
---|---|
136 | |
118 | |
101 | |
71 | |
61 |