Forum Discussion
AudreyWen
Helper I
Helper IMeasure only at selected row
Hi All, I use a measure in a report and i want this measure only to use the rows with a specific selected value. A row has a status in column "Status". for example: "Delivered" or "Open" or "...
OK. So then, what's exactly wrong with the measure with my additions? Because we still don't know...
Best
D
Best
D
AudreyWenHelper I
Helper IHi,
I don't know. Maybe nothing is wrong with it, but maybe there are to many rows (60.565) in the dataset and that will only be more everytime.
In my first measure it was the same problem it kept on loading when i put the measure in my report. Then I have made a new dataset with an Excelfile with only the rows with the status i need (741 rows at the moment, sometimes it will be more or less), then the measure works perfectly in my report. Only now I have to update my model, export the rows to Excel everytime and than i must update the model again. This will be to confusing if my colleagues have to work with this later on. I'm hoping to find a way that it will work at ones.