Power BI is turning 10, and we’re marking the occasion with a special community challenge. Use your creativity to tell a story, uncover trends, or highlight something unexpected.
Get startedJoin us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.
Hi ,
I have a table as shown in the screenshot .
Then it should compare the sum of the amount for each purchase element for each date that we select in the slicer.
Let the two compare measures be Compare 1 and Compare 2. So the requirement is that when I choose a date in slicer one and a Type in costing type slicer one
it should affect data in compare one . and when I choose the date and type in slicer two it should affect the sum in comparing 2.
For example :
If I choose 28th April 2019 and Type 1 in slicer 1 and 29th April 2019 and Type 3 in slicer two than it should show ,
sum of the amount of Type 1 on 28th april Vs sum of the amount of type 3 on 29th April n the same visualisations. Currently, if I am using two different dates or two different types it shows be blank data.
sample table data
sample visualisation
blank visual if two dates are choosen
Any idea will be welcome. Please tell if the requirement is clear.
Thanks in advance.
Solved! Go to Solution.
Hi @Anonymous
I can create two measure to show values of comparing 1 and comparing 2.
First, create two tables
filte1 = CROSSJOIN(VALUES('Table'[type]),VALUES('Table'[date])) filter2 = CROSSJOIN(VALUES('Table'[type]),VALUES('Table'[date]))
They have no relationship with others.
Then add "date" and "type" from two tables in slicers.
Create measures
compare1 = CALCULATE(SUM('Table'[amount]),FILTER(ALLEXCEPT('Table','Table'[item]),'Table'[type]=SELECTEDVALUE('filte1'[type])&&'Table'[date]=SELECTEDVALUE(filte1[date]))) compare2 = CALCULATE(SUM('Table'[amount]),FILTER(ALLEXCEPT('Table','Table'[item]),'Table'[type]=SELECTEDVALUE('filter2'[type])&&'Table'[date]=SELECTEDVALUE(filter2[date])))
Best Regards
Maggie
Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @Anonymous
I can create two measure to show values of comparing 1 and comparing 2.
First, create two tables
filte1 = CROSSJOIN(VALUES('Table'[type]),VALUES('Table'[date])) filter2 = CROSSJOIN(VALUES('Table'[type]),VALUES('Table'[date]))
They have no relationship with others.
Then add "date" and "type" from two tables in slicers.
Create measures
compare1 = CALCULATE(SUM('Table'[amount]),FILTER(ALLEXCEPT('Table','Table'[item]),'Table'[type]=SELECTEDVALUE('filte1'[type])&&'Table'[date]=SELECTEDVALUE(filte1[date]))) compare2 = CALCULATE(SUM('Table'[amount]),FILTER(ALLEXCEPT('Table','Table'[item]),'Table'[type]=SELECTEDVALUE('filter2'[type])&&'Table'[date]=SELECTEDVALUE(filter2[date])))
Best Regards
Maggie
Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
@Anonymous
Hi,
Is your requirement to compare the total costing for two different date ranges?
Rgds,
Vivek
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Check out the June 2025 Power BI update to learn about new features.
User | Count |
---|---|
72 | |
71 | |
57 | |
38 | |
36 |
User | Count |
---|---|
83 | |
67 | |
62 | |
46 | |
45 |