Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
107 | |
94 | |
77 | |
63 | |
50 |
User | Count |
---|---|
147 | |
106 | |
104 | |
87 | |
61 |