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

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's avatar
Zubair_Muhammad
Icon for Community Champion rankCommunity Champion
8 years ago

Hi Anonymous

 

Could you show me a screen shot? or share the file?

How are the tables related?

  • 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