Forum Discussion
Helper IICreate 2 Measures from 2 different slicers
Hi
I have a table - total data.
In the table, i have column with date time, called as Calendar Year/Month, which i will use for user selection.
I have created 2 different slicers for the same dimension with the option of single select, as i want the user to select Month 1 in Slicer 1 and another month (Month 2) in slicer 2
Based on the above selection by the user, i want to have 2 different measures, which reference the different slicers selection, so that i can proceed to perform other calculations.
Measure 1 will filter data based on the selections done in Slicer 1 and Measure 2 based on selections in Slicer 2.
Can someone please guide me on how to do this in Power BI
Sai_Alkesh can you check wht selected value you get in 2nd measure. It should logically work, without looking at pbix it is very hard to tell what is going on. Do you have any fitler , may be update measure to ALLSELECTED instead of ALL
10 Replies
- parry2k
Super User
Sai_Alkesh you have to have two seperate dimension table to achieve this and then you can use respective dimension in your mesure.
Sai_Alkeshparry2k do i need to create another table with the column of Calendar Year/Month and reference that in slicer 2 ?
Sorry, but am not clear on the solution offered
Thanks for the help.
- parry2k
Sai_Alkesh that's exactly correct, create another table and use that in slicer2.