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 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.
Thanks so much Ashish! Your solution has helped me so much!!
Really appreciate your time and expertise!
You are welcome.