cancel
Showing results for
Did you mean:
Frequent Visitor

## % Percentage by day and category in a matrix and in a line chart

Hi, since multiples days I'm trying to create a percentage column in my Power BI project but I can't find any matching situation on the internet that could help me.

So, as you can see in the first table, I have a row "closed",

in the second table, the number of "closed" that were rejected,

and in the last one the number of "closed" - "closed rejected"

And I want to display the percentage of the last one compared to the total of the first one. In a table and in a line chart. So I think I need a new "DAX calculated" column in my data. (I don't know if I'm clear  )

I need to get the percentage of State= "closed" that are not Closing reason = "Rejected" by day (Compared to the total number of state each day)

Thanks!

1 ACCEPTED SOLUTION
Community Support

You can create your measures like so:

`Count = COUNTROWS('Table')`
```Percentage of Closed =
DIVIDE (
CALCULATE (
[Count],
ALLEXCEPT ( 'Table', 'Table'[Date] ),
'Table'[State] = "Closed",
'Table'[Closing Reason] <> "Rejected"
),
CALCULATE ( [Count], ALLEXCEPT ( 'Table', 'Table'[Date] ) )
) + 0

```

Best Regards,

Icey

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

2 REPLIES 2
Community Support

You can create your measures like so:

`Count = COUNTROWS('Table')`
```Percentage of Closed =
DIVIDE (
CALCULATE (
[Count],
ALLEXCEPT ( 'Table', 'Table'[Date] ),
'Table'[State] = "Closed",
'Table'[Closing Reason] <> "Rejected"
),
CALCULATE ( [Count], ALLEXCEPT ( 'Table', 'Table'[Date] ) )
) + 0

```

Best Regards,

Icey

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Frequent Visitor

Announcements