Forum Discussion
Previous Value from slicer selection
Hi, Wondering if anyone can help me on this one: I have the following simple measure: Total = COUNTROWS('Fleet (Cars)') In another table we have the labels for year ranges such as: ...
Hi again,
Just to let you know we've managed to figure it out with the following:
var a = CALCULATE(Max('Ranges'[Index])-1) var b = CALCULATE(
DISTINCTCOUNT('Fleet (Cars)'[id]);
filter(
ALL('Fleet (Cars)');true());'Ranges'[Index]=a;) return bRegards,
Matt
Zubair_Muhammad
Community Champion
Community ChampionHi Anonymous
Give this a shot
Previous =
CALCULATE (
COUNTROWS ( 'Fleet (Cars)' ),
FILTER (
ALL ( 'Ranges'[Index] ),
'Ranges'[Index]
= SELECTEDVALUE ( 'Ranges'[Index] ) - 1
)
)Thanks Zubair_Muhammad but getting a multiple column error on this one:
The expression refers to multiple columns. Multiple columns cannot be converted to a scalar value.
- Zubair_Muhammad
Hi Anonymous
Could you show me a screen shot? or share the file?
How are the tables related?
Relation is a bidireccional one to many between the IDs of the ranges:
Zubair_Muhammad Thanks for your assistance!
Matt
Hi again,
Just to let you know we've managed to figure it out with the following:
var a = CALCULATE(Max('Ranges'[Index])-1) var b = CALCULATE(
DISTINCTCOUNT('Fleet (Cars)'[id]);
filter(
ALL('Fleet (Cars)');true());'Ranges'[Index]=a;) return bRegards,
Matt