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 data where I need to Calculate Percentage and also have Filters for the data around 6,7.
For example
Customer ID WinOrders TotalOrders Geo Territory Segment
12 5 9 NA NA_ENT Tier1
12212 5 9 NA_CAN NA_T2 Tier3
13412 5 9 NA NA_T1 Tier2
I have to calcualte Percentage for all the GEO level Territory Level Segment Level
When using powerBI I am unable to get the ratios when I apply filters,
Can anyone help me with this
Thanks
Any help/solution is appreciated
Thanks
I'm not clear about your expected result. But based on your description, you can use ALLSELECTED() function in your CALCULATE() formula to make the context take the applied filters. Please refer to this article: Understanding ALLSELECTED
Regards,
wrote:
I'm not clear about your expected result. But based on your description, you can use ALLSELECTED() function in your CALCULATE() formula to make the context take the applied filters. Please refer to this article: Understanding ALLSELECTED
Regards,
Thanks for the link it is helpful but my issue is
I have total count, Win count, Price for the products,
I need to calculate the ratio as
Win Ratio = Win Count/Total Count
Price Ratio = Price / Win Count and use the filters accordingly.
Thanks
Thanks any suggestion will be helpful
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 |
---|---|
98 | |
97 | |
81 | |
77 | |
66 |
User | Count |
---|---|
126 | |
105 | |
103 | |
81 | |
72 |