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.
Hello guys, I'm sure I'm doing something really wrong but I can't understand what it is exactly, I guess it's about context but I don't know...
I have a calendar table and I created a custom column (NombresSemanasGráficos) so I can rename the weeks to S-Actual (current week), S-1, S-2, S-3... to previous weeks and then I group "S-6 to S-10" and" S-11 to S-15" into both groups S-6-10 and S-11-15.
I want to show Average data for week for both groups of weeks (S-6-10 and S-11-15) and for the rest I want to sum data.
[suscrpciones nuevas] it's just a SUM of data.
So I made this measure:
TEST SEMANAS =
IF(
VALUES(Calendario[NombresSemanasGráficos])="S-6-10",
CALCULATE(
AVERAGEX(SUMMARIZE(Calendario, Calendario[Semana consecutiva], "Avg", [Suscripciones nuevas]), [Suscripciones nuevas]),
Calendario[ControlSemana]<=-6 && Calendario[ControlSemana]>=-10
),
IF(
VALUES(Calendario[NombresSemanasGráficos])="S-11-15",
CALCULATE(
AVERAGEX(SUMMARIZE(Calendario, Calendario[Semana consecutiva], "Avg", [Suscripciones nuevas]), [Suscripciones nuevas]),
Calendario[ControlSemana]<=-11 && Calendario[ControlSemana]>=-15
),
[Suscripciones nuevas]
)
)
And this is how it's working fine on a line chart with correct values for AVG and SUM:
But when I try to use it on a table so the customcolumn NombresSemanasGráficos are the columns and the measure the values (same as the line chart) it shows the following error:
What I'm missing here?
If you need anything I can upload a sample .pbix and translate it if needed.
Thank you!!
Solved! Go to Solution.
@Anonymous - A sample PBIX would be helpful. That said, my first suspicion is your use of VALUES, try replacing with MAX maybe.
Thank you @Greg_Deckler !! MAX instead of VALUES worked for me.
I don't think the measure I made is the best way to get the desired result but it works so I can't complain.
Thanks!
@Anonymous - A sample PBIX would be helpful. That said, my first suspicion is your use of VALUES, try replacing with MAX maybe.
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 |
---|---|
106 | |
105 | |
79 | |
69 | |
62 |
User | Count |
---|---|
143 | |
104 | |
103 | |
82 | |
70 |