Forum Discussion

Controller_CVL's avatar
Controller_CVL
Frequent Visitor
4 years ago

status count with measures

I need help with something that can be simple, basically I have a measure that returns a certain status, increased, decreased or sporadic, this measure does not use column information but the result of other measures to determine its final value, so I don't I can only do a count because it returns an error, I have an idea that I must use a virtual table and do a count with a filter, however it only returns the total amount, it does not return the status I selected, and that's what I need help with , see attached image.

 

 

 

4 Replies

  • onurbmiguel_'s avatar
    onurbmiguel_
    Icon for Power Participant rankPower Participant

    Hello Controller_CVL

     

    May i sugest to use "summarize" to create a virtual table and then make your calculation.

     

    Did I answer your question? Mark my post as a solution! Appreciate your Kudos!! ;-
    Best Regards
    BC

    • Controller_CVL's avatar
      Controller_CVL
      Frequent Visitor

      I've already done it this way, but it's only returning the total value and not the value I asked for in the filter.

      • onurbmiguel_'s avatar
        onurbmiguel_
        Icon for Power Participant rankPower Participant

        Hi again, 

        Please share an example with some data , so i can understand what you want.

         

        BR 

        Bruno