Forum Discussion
Switch and Counts are not working
Hi Team, i am having the data as below. Error_Message Value Name A Name, Address A Address A Name,Address,Phone A Address,Phone A Phone A Name, Phone A Name,Ad...
Johanno
Continued Contributor
Continued ContributorSince noone else has replied:
If you have a limited amount of error codes and a limited amount per row you could:
1. Use Power Query to separate to columns with comma seperator
2. Create one measure per error code:
Name = CALCULATE(COUNTROWS(Test);Test[Column1.1]="Name") + CALCULATE(COUNTROWS(Test);Test[Column1.2]="Name") + CALCULATE(COUNTROWS(Test);Test[Column1.3]="Name")
Phone = CALCULATE(COUNTROWS(Test);Test[Column1.1]="Phone") + CALCULATE(COUNTROWS(Test);Test[Column1.2]="Phone") + CALCULATE(COUNTROWS(Test);Test[Column1.3]="Phone")
etc.
But this is probably not a good looking solution.
Here was a similar question:
Thanks Johanno.
I am not able to achive the expected result with this solution.
I tried spliting the column based on delimiter comma by rows and use the Switich and Count its working.
Regards,
Udsan