Forum Discussion
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_
Power 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_CVLFrequent 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_
Power Participant
Hi again,
Please share an example with some data , so i can understand what you want.
BR
Bruno