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 all,
I have a data set with columns like this:
Donor ID Staff Donor
01 TRUE
02 TRUE
02 TRUE
03 FALSE
04 FALSE
05 TRUE
06 TRUE
07 FALSE
07 FALSE
I want to calcuate the percentage of staff donors to all donors. My thought is first to calcuate the number of staff donor first by distinct count donor ID if staff donor = TRUE. I created a new measure like this:
Solved! Go to Solution.
The error could be that it is a boolean column and you are comparing it to text? Not sure, can you click the More details and post what it says? Also is Lookup ID correct or Donor ID? Whatever your final formula, you can get percentage by right clicking, Show as and then Percent of Total.
@DianaT If it's the boolean that's being problematic, you could try these:
Respectfully,
Zoe Douglas (DataZoe)
Follow me on LinkedIn at https://www.linkedin.com/in/zoedouglas-data
See my reports and blog at https://www.datazoepowerbi.com/
@DianaT If it's the boolean that's being problematic, you could try these:
Respectfully,
Zoe Douglas (DataZoe)
Follow me on LinkedIn at https://www.linkedin.com/in/zoedouglas-data
See my reports and blog at https://www.datazoepowerbi.com/
Hi,
Thank you so much for your help. I changed the filter to [Staff donor] = true() and it is working like a dream now!
🙂 Diana.
The error could be that it is a boolean column and you are comparing it to text? Not sure, can you click the More details and post what it says? Also is Lookup ID correct or Donor ID? Whatever your final formula, you can get percentage by right clicking, Show as and then Percent of Total.
Hi Greg,
Thank you so much for your help. It is a indeed a problem with the boolean column. All sorted now!
🙂 Diana
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 |
---|---|
109 | |
98 | |
80 | |
64 | |
57 |
User | Count |
---|---|
145 | |
110 | |
91 | |
84 | |
66 |