(Note my file is still too big to upload. I have tried to take extra calcs and other measure calc tables i had)
Hi All
Scenario
I am grouped the Total Sales in buckets of Low, Mid, High. So if sales are <=X it is seen as either in one of these buckets. The grouping for “Low Weekly Sales” I can see is £465,413.82. Great!
Issue
The issue I have is I want to view the £465,414 number by my Customer Names.
The calculations I have done for “Low Weekly Sales”
Low Weekly Sales = CALCULATE(SUMX(
FILTER(SUMMARIZE(Orders,Dates[WeekEnding]),
[Total Sales]>0 && [Total Sales]<=SELECTEDVALUE(‘Low Weekly Parameter’[Low Weekly Parameter])),[Total Sales]))
Please can somone kindly assist.
This part of Power BI i still find really difficult to get my head around!
If someone can give me a sample function on here and explain.
Thanks a lot !
Shrik
