Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
Deepak3Arora
Frequent Visitor

Power BI - Grouping Issue

I am trying to Develop a Dashboard with Matrix Layout based on below type of data

Date                         SLA       Type      Group

9/1/22 10:00 AMMeetsIncidentApplication
9/1/22 11:00 AMMissedRequestApplication
9/3/22 8:00 AMMeetsRequestApplication
10/4/22 6:00 AMMissedRequestApplication
10/6/22 10:00 PMMeetsIncidentApplication
9/6/22 10:23 AMMeetsIncidentInfrastructure
9/6/22 10:12 AMMissedIncidentApplication
10/8/22 6:00 PMMeetsRequestInfrastructure
10/9/22 8:00 PMMissedRequestInfrastructure
9/3/22 9:00 AMMeetsRequestInfrastructure

 

I need to find percentage of Meets records versus total no of records for that month as column and type/Group as row in a matrix row.

 

I am able to find count of records but not percentage of Meets Records with total for that month/type/group.

Deepak3Arora_0-1653733879714.png

 

Any Help would be really really appreciable.

1 ACCEPTED SOLUTION
Fowmy
Super User
Super User

@Deepak3Arora 

You use a measure as follows:

Meets % = 
DIVIDE(
    CALCULATE(
        COUNTROWS( Table ),
        Table[SLA] = "Meets"
    ),
    COUNTROWS(Table)
)
Did I answer your question? Mark my post as a solution! and hit thumbs up


Subscribe and learn Power BI from these videos

Website LinkedIn PBI User Group

View solution in original post

2 REPLIES 2
Deepak3Arora
Frequent Visitor

Thank You so much @Fowmy , Exactly what I needed.

 

Keep Rocking.

Fowmy
Super User
Super User

@Deepak3Arora 

You use a measure as follows:

Meets % = 
DIVIDE(
    CALCULATE(
        COUNTROWS( Table ),
        Table[SLA] = "Meets"
    ),
    COUNTROWS(Table)
)
Did I answer your question? Mark my post as a solution! and hit thumbs up


Subscribe and learn Power BI from these videos

Website LinkedIn PBI User Group

Helpful resources

Announcements
PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.