Forum Discussion
Helper IICreate 2 Measures from 2 different slicers
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
Super UserSai_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.
- Sai_Alkesh
parry2k i created another table M2 with no relationship to the total data table (table1)
How do i create a measure 2, that would require calculations to be performed in the columns in table1, based on the selections done in the slicer 2 of table 2 (M2) ?