Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
How to get value of percentage of collumns in a measure for data below
Year | Filled |
2020 | 1 |
2021 | 1 |
2022 | 1 |
2023 | 1 |
2024 | 1 |
2025 | 1 |
2026 | 0 |
2027 | 0 |
2028 | 0 |
2029 | 0 |
I want to achive
% of count = (Total count for value -0) / Total count ) * 100 |
for example above result should be = (4/10 ) * 100
Solved! Go to Solution.
@Anonymous
Did get it right I believe, if you want to count records with zero and divide **bleep** by total count then use this measure:
Measure1 =
DIVIDE(
CALCULATE( COUNTROWS( Table ), Table[Filled] = 0),
COUNTROWS( Table )
)
________________________
If my answer was helpful, please consider Accept it as the solution to help the other members find it
Click on the Thumbs-Up icon if you like this reply 🙂
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
@Anonymous
Did get it right I believe, if you want to count records with zero and divide **bleep** by total count then use this measure:
Measure1 =
DIVIDE(
CALCULATE( COUNTROWS( Table ), Table[Filled] = 0),
COUNTROWS( Table )
)
________________________
If my answer was helpful, please consider Accept it as the solution to help the other members find it
Click on the Thumbs-Up icon if you like this reply 🙂
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
User | Count |
---|---|
94 | |
86 | |
78 | |
69 | |
63 |
User | Count |
---|---|
114 | |
99 | |
97 | |
65 | |
59 |