Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
There is a table that has values like below.
There are lines that say "Not OK". The number of these lines is 100%
How can I make a graph and a filter so that when I select a specific problem, I see how many percent of such lines are from the total number of lines, where are they in the Not OK status?
I tried the "Percentage of Grand Total" option in the values menu, but obviously it doesn't show what I want.
id | Status | Problem |
1 | OK | |
2 | Not OK | 1 |
3 | OK | |
4 | OK | |
5 | OK | |
6 | Not OK | 2 |
7 | OK | |
8 | OK | |
9 | OK | |
10 | Not OK | 3 |
11 | Not OK | 1 |
12 | Not OK | 2 |
13 | OK | |
14 | OK | |
15 | OK | |
16 | OK | |
17 | OK | |
18 | Not OK | 4 |
19 | Not OK | 4 |
20 | OK | |
21 | Not OK | 2 |
22 | Not OK | 3 |
23 | OK | |
24 | OK | |
25 | OK |
Solved! Go to Solution.
Hi @Anonymous ,
Will "sum (number of Not OK)" be filtered by month? If it will ,try the first measure, if not, try second.
measure1 =
var select_count=calculate(count('table'[id]),filter(all('table'),'table'[month]=selectedvalue('table'[month])&&'table'[problem]=selectedvalue('table'[problem])&&'table'[status]="Not OK"))
var all_count=calculate(count('table'[id]),filter(all('table'),'table'[month]=selectedvalue('table'[month])&&'table'[status]="Not OK"))
return
select_count/all_count
measure2 =
var select_count=calculate(count('table'[id]),filter(all('table'),'table'[problem]=selectedvalue('table'[problem])&&'table'[status]="Not OK"))
var all_count=calculate(count('table'[id]),filter(all('table'),'table'[status]="Not OK"))
return
select_count/all_count
Best Regards,
Jay
Hi, @Anonymous
I am not sure if I understood your question correctly, but please check the below picture and the sample pbix file's link down below whether it is what you are looking for.
All measures are in the sample pbix file.
https://www.dropbox.com/s/qmcdq55u87n3o9u/uk141.pbix?dl=0
Hi, My name is Jihwan Kim.
If this post helps, then please consider accept it as the solution to help other members find it faster, and give a big thumbs up.
Linkedin: linkedin.com/in/jihwankim1975/
Twitter: twitter.com/Jihwan_JHKIM
If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.
Not. The axis should be the month, which I did not show in the example.
To the left of the visualization there should be a Slicer, which allows you to select the desired problem and see on the graph the number of lines with this problem / sum (number of Not OK)
Hi @Anonymous ,
Will "sum (number of Not OK)" be filtered by month? If it will ,try the first measure, if not, try second.
measure1 =
var select_count=calculate(count('table'[id]),filter(all('table'),'table'[month]=selectedvalue('table'[month])&&'table'[problem]=selectedvalue('table'[problem])&&'table'[status]="Not OK"))
var all_count=calculate(count('table'[id]),filter(all('table'),'table'[month]=selectedvalue('table'[month])&&'table'[status]="Not OK"))
return
select_count/all_count
measure2 =
var select_count=calculate(count('table'[id]),filter(all('table'),'table'[problem]=selectedvalue('table'[problem])&&'table'[status]="Not OK"))
var all_count=calculate(count('table'[id]),filter(all('table'),'table'[status]="Not OK"))
return
select_count/all_count
Best Regards,
Jay
@Anonymous , Try one of the two measure
divide(calculate(count(Table[ID]), filter(Table, search("Not OK",Table[Status],,0)>0)), calculate(count(Table[ID])))
divide(calculate(count(Table[ID]), filter(Table, search("Not OK",Table[Status],,0)>0)), calculate(count(Table[ID]), allselected(Table)))
Both are not. I need a Slicer on the side, which would allow me to show only a certain problem, but to see not just the quantity, but the quantity with this problem / the quantity Not OK of everything.
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
63 |
User | Count |
---|---|
135 | |
126 | |
110 | |
70 | |
61 |