cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
jmiridium Member
Member

Charts from Different Results

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?

5 REPLIES 5
jmiridium Member
Member

Re: Charts from Different Results

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 Super Contributor
Super Contributor

Re: Charts from Different Results

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 Member
Member

Re: Charts from Different Results

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

v-huizhn-msft Super Contributor
Super Contributor

Re: Charts from Different Results

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

v-huizhn-msft Super Contributor
Super Contributor

Re: Charts from Different Results

Hi @jmiridium,

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

Best Regards,
Angelia

Helpful resources

Announcements
GregDeckler

How to Get Your Question Answered Quickly

Power BI Super User, Greg Deckler, explains

Summit North America

Power Platform Summit North America

Register by September 5 to save $200

Back to School Contest

Back to School Contest

Engage and empower students with Power BI!

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Top Ideas
Users Online
Currently online: 104 members 1,529 guests
Please welcome our newest community members: