Forum Discussion
Problem with line graph
I can but will take time but have a look. With an extra filter in a differen column i have the issue
The filter is a simpler slide - let me know if you can figure out -if not I ll sent the file
without the filter, no problem
What value are you using for the slicer and how is it related to the filter and measure?
- raffbr29 years agoFrequent Visitor
Unrelated... the slide measure is not used on the measure (below) - the only difference between the correct graph and the messy one is that I removed the slide on a column that is not used on the measure.
ScoreTot =
CALCULATE (
(sumX(FILTER(Dados, Dados[resultado]="a"),Dados[Numrec]*[PesoAcordo])-
sumX(FILTER(Dados, Dados[resultado]="p"),Dados[Numrec])+
sumX(FILTER(Dados, Dados[resultado]="i"),Dados[Numrec])-
sumX(FILTER(Dados, Dados[resultado]="r"),Dados[Numrec])+
sumX(FILTER(Dados, Dados[resultado]="e"),Dados[Numrec])
)/sum(Dados[NumRecords]),
FILTER(ALL ( Dados[dataMovIni] ),
Dados[dataMovIni] <= MAX ( Dados[dataMovIni] ) )
)- richbenmintz9 years agoResident Rockstar
My guess is that the slice value is effecting the filter context of your measure.
- raffbr29 years agoFrequent Visitor
I did a calculated column when 1 is for values > 10000 and 0 for less. It worked -
**bleep**, how come a slices is different than a calculated column????????