Forum Discussion
Filter on certain filter category
On the left is my date table and on the right the wholesale table, the 2 are linked on Date = Sale_Date.
The calculation for Total Wholesale
Total Wholesale = calculate(sum('Wholesale'[Wholesale]);'Wholesale'[Segment]<>"3. Other")It sums the wholesale column and excludes one segment.
Microsoft EmployeeHi MxJ,
Please download a demo from the attachment. All the date like fields should from the Real_Date table.
Best Regards,
Thanks for your reply.
The only problem I have is that the formulas dont work when I use the real_date table is steady of the date from the wholesale table.. It returns "empty" when i use:
Total Wholesale YTD = TOTALYTD([Total Wholesale];'Real_date'[Date])
Also, the figure from januari still does not show at Q1. 2019 gives -0,90 while januari gives 0,32 in your example.
I need Q1 and 2019 to say 0,32 as well.
- v-jiascu-msft
Hi MxJ,
Can you share a similar sample like mine? Please mask the sensitive parts first.
Best Regards,
My data is the same as your sample. The problem is that I need 2019(-0.9) and Qtr 1(-0.57) to be 0.32,, just like Januari. It sets Februari and march at 0 when calculating their own value but still take them into account when calculating 2019 and Qtr 1.