Selecting specific values in Measure-Columns for Reports
Hi there!
I have an Issue regarding the use of Measures (and maybe a bit of a lack of understanding as to what the underlying reasons are for this Issue to arise).
My Task:
I have a set of data, containing the IDs of Cars and different codes for service options that have to be done to this cars, as well as the status of these service options. One ID can either have one or more of the same service options at the same time. Now I want to create a table that lists all Car-IDs that have more than one service option open at the same time.
To achieve this, I wanted to simply create a measure counting all service options per ID that are in a defined set of status. This works, but so far shows also the IDs that only have 1 service option per ID.
My Problem:
I don`t know how to filter measures, since I can`t just say "select all values bigger 1". When putting it in an expression, I get the error "invalid Dimension".
My second try was to go via an expression like i.e. "=if(count(serviceOption)>1, serviceOption,null())" and then simply hide zero-values which, however, only works with dimensions, not measures.
So now my Question sums up basically into: How can i select or filter specific values in measure columns in tables (Like either "show only value "x" or "show greater than x")?
