Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
I am trying to figure out how to do something but cant quite grasp it, can someone help me?
So here is a table that I have:
We have dates that will grow progressively, we have some breakdown in the second column, i just made this up in fact I have upto 10 rows per date, then we have the sales for that day, the Sales Fro Selected Period is a Measure:
Sales For Selected Period = CALCULATE(SUM(Table[Sales For Date]), ALLSELECTED(Sales For Date))
Basically where the Sales For Selected Period column is i want the date 4/20/2022 to show 26671 on as many rows as there are for 4/20/2022, then for rows where we have 4/19/2022 i want then umber to show 20502 for as many rows as that date is present, etc.
Basically for me to figure out a rate of sales (just thought this up dont mind it) I need to have it on a per date basis to show in a single visual later, so i need the rates to be relative to the Date even if shown inside single table where 100% will be individual for Sales for Date per each day.
This is a manually made table with result i want in pre-last column and how it would be used in the last column instead of what i have in first screenshot:
Solved! Go to Solution.
Hi @dkalinai
Assuming that the date column in from the same table then you may try
Sales For Selected Date = CALCULATE(SUM(Table[Sales For Date]), ALLEXCEPT (Table, Table[Date]))
Hi @dkalinai
Assuming that the date column in from the same table then you may try
Sales For Selected Date = CALCULATE(SUM(Table[Sales For Date]), ALLEXCEPT (Table, Table[Date]))
Hi,
I have a similar problem, but my date column is in different table for which I have already created relationship between the two tables but its not working, please help.
Hi @Ayushi_01
Instead of ALLEXCEPT you can remove the filter of every column placed in the table visual other than the Date column using either ALL or REMOVEFILTERS
You are Brilliant! I spent the day figuring this out, i was sceptical to try the ALLEXCEPT thinking it did something else but your solution is xactly what I need! Thank you! Sending you lots of Karma points!