Forum Discussion
Calculating a ratio based on partial text values
Share the download link of the PBI file with the 3 visuals already built there.
Hi,
PBI file attached.
Hope this helps.
This is really helpful.
When i run the Is the Service Initial measure, I get the error:
A single value for column 'Item' in table 'Master Activity Report' cannot be determined. This can happen when a measure formula refers to a column that contains many values without specifying an aggregation such as min, max, count, or sum to get a single result.
Could it be because my service value descriptions are long. Here is an example:
I do not know the reason. Review my solution carefully and retry.
Sorry, you are correct. It was an error at my end.
However, when I look at my data, the number is Is my service initial? calculation is less then if I run a filter manually, selecting only those services which have the term initial. This is not doing a distinct count is it?
Really appreciate your help.
