Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

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:     ...
Need Help
  • Anonymous's avatar
    Anonymous
    8 years ago

    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 b

    Regards, 

     

    Matt

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Relation is a bidireccional one to many between the IDs of the ranges:

 

 

Zubair_Muhammad Thanks for your assistance!

 

Matt

Anonymous's avatar
Anonymous
Not applicable
8 years ago

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 b

Regards, 

 

Matt