Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more
Hello I have a variable that is binary "1" and "0", I would like to obtain the percentage of the values equal to 1 but of the total, that is, the total would be the observations that are worth 1 and 0, how could I generate measures to reach this goal?
If I help you, can make this question like solved?
Goog Night, man
Can you try this:
%_1 =
var total = count(YOURCOLUMN)
var count1 = calculate(count(YOURCOLUMN),YOURCOLUMN='1')
var result = count1/total
return result
Switch this measure do data % and bee happy!
Make this same process to "zero".
The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!
| User | Count |
|---|---|
| 44 | |
| 43 | |
| 33 | |
| 30 | |
| 27 |
| User | Count |
|---|---|
| 134 | |
| 114 | |
| 58 | |
| 57 | |
| 57 |