Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
94 | |
81 | |
66 | |
58 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |