Forum Discussion
max in pre-aggregate table
Goodnight
It's been a while since I've been back here, the truth is that with so much work sometimes time becomes too limited, however I didn't want to let this post go by without including the solution so that if someone else is in the same predicament they can find it here a guide and a solution.
Basically the syntax that works is:=
CALCULATETABLE (
ADDCOLUMNS ( ALL ( Calendario[Nombre del día] ), "@hurtos", [cantidad] ),
REMOVEFILTERS ( Calendario[Número del día] )
)this excellent video explains what is happening, it really is something that is not at all intuitive
Finally, the measure was needed to place a conditional format, therefore the final one is as follows:
color bars =
VAR table =
CALCULATETABLE (
ADDCOLUMNS ( ALL ( Calendar[Day name] ), "@thefts", [amount] ),
REMOVEFILTERS ( Calendar[Day of week] )
)
maximum VAR =
MAXX ( table, [@thefts] )
VARE color =
SWITCH ( TRUE (), [amount] >= maximum, "#8C0000", "#BDBEBF" )
RETURN
color
hope this helps in some way
Hi jcamilo1985
What kind of relationship is there beween the two tables? You are slicing by day name from the calendar table, right? Would you please try retun COUNTROWS ( resumen ) and see what results you get. My understanding that you want the max value fro each day name among all weeks so I believe ADDCOLUMNS should be iterating over VALUES ( Year- Week )
This is how the relationship between calendar and facts is constructed.
In effect what I am looking for is that for each day of the week the value is 75653 for this case
What is the code of [Amount]?