Charts from Different Results

[jmiridium]

I have a chart of data from Excel. In the columns there are different results, ie, Skipped, OK, Error. I would like to create a chart of how many are OK, how many are error, and how many are OK from multiple rows. Suggestions?

[jmiridium]

I'm trying to create a filter result:

SkippedNotInstalled = CALCULATE(COUNT(Report20170410[Acrobat]),FILTER(Report20170410[Acrobat] = 'Skipped (not installed)'))

I would like to add columns and have the same filter on each column

[v-huizhn-msft]

Hi @jmiridium,

>>I have a chart of data from Excel. In the columns there are different results, ie, Skipped, OK, Error.

From this sentence, I understand the Skipped is a value in one column. While in the given DAX, you use 'Skipped (not installed)', ‘Skipped’ is like a table. 

So I am confusing for your requirements and your resource table. Please post screenshot and sample table in details for further analysis.

Thanks,
Angelia

[jmiridium]

'Skipped (not installed)' is the response in the field parenthesis and all

[v-huizhn-msft]

Hi @jmiridium,

Have you resolved your problem? If you have resolved your problem, please mark the corresponding reply as answer. 

Best Regards,
Angelia

[v-huizhn-msft]

Hi @jmiridium,

I am still confusing your requirement, I post the solutions based on my understanding. It it not what you want, please feel free to ask and post more details.  You can create mutiple measures, and create a slicer including measure name.

SkippedOK = CALCULATE(COUNT(Report20170410[Acrobat]),FILTER(Report20170410[Acrobat] = 'Skipped (Ok)'))
SkippedError = CALCULATE(COUNT(Report20170410[Acrobat]),FILTER(Report20170410[Acrobat] = 'Skipped (Error)'))

When you select the SkippedOK in slicer, it will return how many are OK. When you select SkippedError, it will return how many are Error.

Here is a similar thread for your referance.

Thanks,
Angelia