Forum Discussion
Card result based on two different filters
Microsoft EmployeeHi lusalva,
In order to avoid the influence between two slicers, rather than adding the same column in two slicers, rather than referring to the same data table in two measures, you should recreate a second table which contains all the columns in original table.
In slicer1, add product column from table1, in slicer2, add product column from table2. In measure [sales_prod_1], calculate the values in table1 and calculate values in table2 in measure [sales_prod_2].
Best regards,
Yuliana Gu
Hi Yuliana,
I tried that now, and it does not work.
I duplicated the table and called benchmark_2, so now on slicer 1 I entered the sales_prod_1 that contains values for products on benchmark_1 and on slicer 2 I entered the sales_prod_2 that values for products on benchmark_2 and in the card I have created a new colunm called 'variation_%' that is calculated this way : variation_% = ((BENCHMARK_1[sales_prod_1 ])/(RELATED(BENCHMARK_2[sales_prod_2 ])))-1
Also I have set the card to not have any interaction
- v-yulgu-msft
Hi lusalva,
In my test, I could get desired result if I duplicated the table.
In table1, I created a measure:
Total1 = CALCULATE(SUM(ClosedTickets[Amount]),ALLEXCEPT(ClosedTickets,ClosedTickets[Category]))
In table2, i created Total2:
Total2 = CALCULATE(SUM('Closed Tickets2'[Amount2]),ALLEXCEPT('Closed Tickets2','Closed Tickets2'[Category2]))
Measure variation_% = DIVIDE([Total1],[Total2])-1
In visual surface:
If in your scenario, you always get 0% in the card which displays variation_%, please format its decimal place.
Regards,
Yuliana GuUnderstood, in this case there is no relationship between the two tables right?
- v-yulgu-msft