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 guys,
I have a table like this
and I'd like a % value on grand total like this
But if I filter customer (only A and C) I'd like this
Can you help me please? 😊
Solved! Go to Solution.
Hi, thank you so much but I have found a easier fomula dax.
Sales % = DIVIDE (SUM(sales), calculate( SUM(sales), ALLSELECTED ('Table customers' (customer))) and work very well 😀
Hi @giuliapiazza94 ,
Create two measure like below:-
Sales_ =
SUMX (
SUMMARIZE ( Sales_data, Sales_data[customer], "sum", [Sales_Total] ),
[sum]
)
Sales_Total =
VAR maxevery =
CALCULATE (
sum ( 'Sales_data'[sales] ),
FILTER ( ALL ( 'Sales_data' ), 'Sales_data'[customer] = MAX ( 'Sales_data'[customer] ) )
)
VAR total_sum =
calculate(SUM ( 'Sales_data'[sales] ),ALL(Sales_data))
RETURN
DIVIDE ( maxevery, total_sum )
Now use customer column and sales_ measure in a table visual
Thanks,
Samarth
Best Regards,
Samarth
If this post helps, please consider accepting it as the solution to help the other members find it more quickly.
Appreciate your Kudos!!
Connect on Linkedin
Hi, thank you so much but I have found a easier fomula dax.
Sales % = DIVIDE (SUM(sales), calculate( SUM(sales), ALLSELECTED ('Table customers' (customer))) and work very well 😀
@giuliapiazza94 , Just check if its working correctly when you select value from filter. 🙂
Best Regards,
Samarth
If this post helps, please consider accepting it as the solution to help the other members find it more quickly.
Appreciate your Kudos!!
Connect on Linkedin
it works if I filter customer and the other tables too (like calendar) 🙂
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 |
---|---|
49 | |
25 | |
20 | |
15 | |
12 |
User | Count |
---|---|
57 | |
49 | |
44 | |
19 | |
18 |