Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Dear All,
I am having some issue in visualization when i apply various filters. Below is my table
When i applied the filter for Ontime/Delayed - month wise its shows 98% ontime and 2% delayed in Jan etc., The same when i select the filter of Cluster instead of Month - it is limited to 25% and showing as 24% and 1% for Africa etc.,
How will i get evel for clusters as 98% and 2% - cluster wise
Month | Empl ID | Ontime/Delayed | Cluster |
Jan-20 | A | Ontime | Africa |
Jan-20 | B | Delayed | Asia |
Jan-20 | C | Ontime | Asia |
Jan-20 | D | Ontime | Asia |
Feb-20 | E | Ontime | America |
Feb-20 | F | Delayed | Asia |
Feb-20 | G | Delayed | America |
Feb-20 | H | Ontime | Africa |
Mar-20 | I | Ontime | America |
Mar-20 | J | Delayed | Asia |
Mar-20 | K | Delayed | Africa |
Mar-20 | L | Delayed | America |
Apr-20 | M | Ontime | Asia |
Apr-20 | N | Delayed | Africa |
Solved! Go to Solution.
Hello@Anonymous
You may use the following measures:
On Time % =
DIVIDE (
COUNTAX (
'Table',
IF ( 'Table'[Ontime/Delayed] = "Ontime", 'Table'[Ontime/Delayed] )
),
COUNTROWS ( 'Table' )
)
Delayed% = 1-[On Time %]
It will give you the following output:
Regards,
Vivek
If it helps, please mark it as a solution
Kudos would be a cherry on the top 🙂
https://www.vivran.in/
Hi, @Anonymous
Based on your description, you may create measures as follows.
Ontime % =
DIVIDE(
COUNTROWS(
FILTER(
ALLSELECTED('Table'),
'Table'[Ontime/Delayed] = "Ontime"
)
),
COUNTROWS(
ALLSELECTED('Table')
)
)
Delayed % =
DIVIDE(
COUNTROWS(
FILTER(
ALLSELECTED('Table'),
'Table'[Ontime/Delayed] = "Delayed"
)
),
COUNTROWS(
ALLSELECTED('Table')
)
)
Result:
If I misunderstand your thoughts, please show me your expected result. Thanks.
Best Regards
Allan
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Is there a measure involved here? What are you expecting the results to be? Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490
Hi,
Yes - there is a measure involved. At cluster level also i wanted the % to be shown @ 100% level within the cluster
Example : In below table - Asia is having 3 line items of which 2 are ontime reporting & 1 is delayed reporting, I wanted the visualization to show as 67% as ontime & 33% as delayed when filterd at cluster level
Thanks and Best Regards,
Srihari.K
Hello@Anonymous
You may use the following measures:
On Time % =
DIVIDE (
COUNTAX (
'Table',
IF ( 'Table'[Ontime/Delayed] = "Ontime", 'Table'[Ontime/Delayed] )
),
COUNTROWS ( 'Table' )
)
Delayed% = 1-[On Time %]
It will give you the following output:
Regards,
Vivek
If it helps, please mark it as a solution
Kudos would be a cherry on the top 🙂
https://www.vivran.in/
User | Count |
---|---|
93 | |
84 | |
78 | |
75 | |
66 |
User | Count |
---|---|
115 | |
105 | |
93 | |
65 | |
60 |