Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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.
User | Count |
---|---|
99 | |
86 | |
78 | |
75 | |
71 |
User | Count |
---|---|
112 | |
105 | |
96 | |
74 | |
66 |