Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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?
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
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
'Skipped (not installed)' is the response in the field parenthesis and all
Hi @jmiridium,
Have you resolved your problem? If you have resolved your problem, please mark the corresponding reply as answer.
Best Regards,
Angelia
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
98 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
100 | |
86 | |
64 |