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

[HugoDEVILLIER]

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!

[Icey · Accepted solution]

Hi @HugoDEVILLIER ,

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.

[HugoDEVILLIER]

I'm sorry, just saw your solution, my problem is gone ! Thank you for your answer