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.
Solved! Go to Solution.
I think it makes more sense to filter before summarizing instead of after.
Try something like this:
Measure for last available month =
VAR LastAvailableMonth = MAX ( 'DB asignaciones'[Month] )
VAR LastAvailableYear = MAX ( 'DB asignaciones'[YEAR] )
RETURN
SUMX (
ADDCOLUMNS (
SUMMARIZE (
FILTER (
'DB asignaciones',
'DB asignaciones'[Month] = LastAvailableMonth &&
'DB asignaciones'[YEAR] = LastAvailableYear
),
'DB asignaciones'[RBD]
),
"PP", CALCULATE ( MAX ( 'DB asignaciones'[Poblacion Potencial RBD] ) )
),
[PP]
)
You can probably simplify it further like this:
Measure for last available month =
VAR LastAvailableMonth = MAX ( 'DB asignaciones'[Month] )
VAR LastAvailableYear = MAX ( 'DB asignaciones'[YEAR] )
RETURN
SUMX (
CALCULATETABLE (
VALUES ( 'DB asignaciones'[RBD] ),
KEEPFILTERS ( 'DB asignaciones'[Month] = LastAvailableMonth ),
KEEPFILTERS ( 'DB asignaciones'[YEAR] = LastAvailableYear )
),
CALCULATE ( MAX ( 'DB asignaciones'[Poblacion Potencial RBD] ) )
)
I think it makes more sense to filter before summarizing instead of after.
Try something like this:
Measure for last available month =
VAR LastAvailableMonth = MAX ( 'DB asignaciones'[Month] )
VAR LastAvailableYear = MAX ( 'DB asignaciones'[YEAR] )
RETURN
SUMX (
ADDCOLUMNS (
SUMMARIZE (
FILTER (
'DB asignaciones',
'DB asignaciones'[Month] = LastAvailableMonth &&
'DB asignaciones'[YEAR] = LastAvailableYear
),
'DB asignaciones'[RBD]
),
"PP", CALCULATE ( MAX ( 'DB asignaciones'[Poblacion Potencial RBD] ) )
),
[PP]
)
You can probably simplify it further like this:
Measure for last available month =
VAR LastAvailableMonth = MAX ( 'DB asignaciones'[Month] )
VAR LastAvailableYear = MAX ( 'DB asignaciones'[YEAR] )
RETURN
SUMX (
CALCULATETABLE (
VALUES ( 'DB asignaciones'[RBD] ),
KEEPFILTERS ( 'DB asignaciones'[Month] = LastAvailableMonth ),
KEEPFILTERS ( 'DB asignaciones'[YEAR] = LastAvailableYear )
),
CALCULATE ( MAX ( 'DB asignaciones'[Poblacion Potencial RBD] ) )
)
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 |