dax help - calculating totals and subtotals from strings

[thealaird]

hi guys,

I have a csv that has several columns containing strings e.g. apple;banana;orange;apple

the strings are outputs from a list of over 200 potential 'fruits' so I cannot name individually within the code

Is it possible to write a dynamic DAX code to extract the total number of fruits per column as well as total number of fruits by fruit

i would like to be able to output a simple bar chart like below

[sjoerdvn · Accepted solution]

I would recommend to not use DAX for this, but to unpivot the columns when loading the data, e.g. using power query.
https://learn.microsoft.com/en-us/power-query/unpivot-column