Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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!
Solved! Go to Solution.
Hi @Anonymous ,
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.
Hi @Anonymous ,
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.
I'm sorry, just saw your solution, my problem is gone ! Thank you for your answer
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
65 |
User | Count |
---|---|
136 | |
117 | |
101 | |
71 | |
61 |