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.
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.
I do not understand your question. Based on the Table that you shared in the first post, show the expected result.
Sorry if I was unclear.
The table on the far left is from manually filtering the data to select only items with the term initial used.
The middle table is the total number of items per person.
The one on the right is using your code to create a new measure. Given the difference, could your code be counting only distinct codes which contain the word 'initial'?
I would just use the filtered number, but I need Power Bi to do the calculation automatically, hence the need for a new measure.
Sorry to keep coming back to you. I know this is proabaly a really easy issue that I am just not understanding.
Share the download link of the PBI file with the 3 visuals already built there.