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!
Does anyone know how to divide one suummarized column by another with a certiain text filter?
My example:
I created a matrix for different types of fruits. There's an Action (which is = 'Purchased' or 'Eaten'). For each type of Fruit I want to calculate % of purchased fruits that have been eaten (column 4 in my matrix).
I would like to create a measure that will translate the following logic: if Action = 'Eaten' then SUM(Items)/ if Action = 'Purchased' then SUM(Items)
Fruit Action Action %
Purchased Eaten
(sum items) (sum items)
Apples 56 12 21.4%
Pears 40 5 12.5%
Thanks a lot for your help!
Solved! Go to Solution.
Try with following
Measure = DIVIDE ( CALCULATE ( SUM ( Table1[Amount] ), Table1[Action] = "Eaten" ), CALCULATE ( SUM ( Table1[Amount] ), Table1[Action] = "Purchased" ) )
Try with following
Measure = DIVIDE ( CALCULATE ( SUM ( Table1[Amount] ), Table1[Action] = "Eaten" ), CALCULATE ( SUM ( Table1[Amount] ), Table1[Action] = "Purchased" ) )
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 | |
95 | |
77 | |
66 | |
53 |
User | Count |
---|---|
144 | |
105 | |
102 | |
89 | |
63 |