Forum Discussion
Solved
Measure to count text values in a column
Hello. I am new to Power BI & DAX. I am using Power BI to create visualizations based on the results of Quality Assurance tests I have performed. My data set consists of a list of vendors and vari...
After importing your data perform transformations via the backend.
Unpivot all the Element columns (Select Vendor the use Unpivot all others)
in Advanced Grouping - > group by Vendor and Result
This will give you the final Count you are after
Downlaod Sample PBIX: Vendor Download
After importing your data perform transformations via the backend.
Unpivot all the Element columns (Select Vendor the use Unpivot all others)
in Advanced Grouping - > group by Vendor and Result
This will give you the final Count you are after
Downlaod Sample PBIX: Vendor Download
Thank you Maria! This provided the solution i needed.