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.
Hello all
I have a table that lists, for example, Customers, with each Customer record having an attribute to say whether or not they've made a purchase.
Customer ID | Purchase Made?
========================
0001 | Yes
0002 | Yes
0003 | No
0004 | No
0005 | Yes
0006 | Yes
I want a Measure (at least I think that's what I need) showing the number of Customers where Purchase Made = Yes, as a percentage of the total number of customers.
I'm fairly new to DAX, so any help would be appreciated.
Thanks
Chris
Solved! Go to Solution.
How about building the Measure you need like this
as Rob Colie says "Never write the same formula twice!"
Total Customers = DISTINCTCOUNT ( Table[CustomerID] )
Number of Customers (who made a Purchase) = CALCULATE ( [Total Customers], FILTER ( Table, Table[Purchase Made?] = "Yes" ) )
% of Customers who made a Purchase =
DIVIDE ( [Number of Customers (who made a Purchase)], [Total Customers], 0 )
Also take a look here for future reference if you need to add additional conditions later on
https://www.sqlbi.com/articles/filter-arguments-in-calculate/
Hope this helps!
How about building the Measure you need like this
as Rob Colie says "Never write the same formula twice!"
Total Customers = DISTINCTCOUNT ( Table[CustomerID] )
Number of Customers (who made a Purchase) = CALCULATE ( [Total Customers], FILTER ( Table, Table[Purchase Made?] = "Yes" ) )
% of Customers who made a Purchase =
DIVIDE ( [Number of Customers (who made a Purchase)], [Total Customers], 0 )
Also take a look here for future reference if you need to add additional conditions later on
https://www.sqlbi.com/articles/filter-arguments-in-calculate/
Hope this helps!
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 | |
99 | |
83 | |
76 | |
66 |
User | Count |
---|---|
120 | |
108 | |
95 | |
83 | |
77 |