Forum Discussion

Deepak3Arora's avatar
Deepak3Arora
Frequent Visitor
4 years ago
Solved

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.

 

Any Help would be really really appreciable.

Need Help
  • Fowmy's avatar
    Fowmy
    4 years ago

    Deepak3Arora 

    You use a measure as follows:

    Meets % = 
DIVIDE(
    CALCULATE(
        COUNTROWS( Table ),
        Table[SLA] = "Meets"
    ),
    COUNTROWS(Table)
)

2 Replies

  • Fowmy's avatar
    Fowmy
    Super User
    4 years ago

    Deepak3Arora 

    You use a measure as follows:

    Meets % = 
DIVIDE(
    CALCULATE(
        COUNTROWS( Table ),
        Table[SLA] = "Meets"
    ),
    COUNTROWS(Table)
)