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
Helper IIparry2k 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.
Super UserSai_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) ?
- parry2k
Sai_Alkesh what is your measure? Can you share?
- Sai_Alkesh
this is measure 1 based on the selection of value in slicer 1
M1ABS = VAR selection = SELECTEDVALUE('total data'[Calendar Year/Month],0000) return sum('total data'[Abs Error Value Final])Total data is table nameAbs Error Value Final is the column name.so for example, if the user selects Jan 19 from slicer 1, then i fetch the total sum of Abs Error value. Likewise i now need to get the data for user selection in Slicer 2 (if the user selects Feb 19 in slicer 2).How do i create another measure, wherein the selectedvalue should be selections from slicer 2Sorry for the jumbled explanation, but am a newbie on Power BI and exploring most of the commands in here to build my report.- parry2k
Sai_Alkesh here is what you can do, i assumed table name /column name in following, you can change as per your model.
M2ABS = VAR selection = SELECTEDVALUE('2nd Table'[Calendar Year/Month],0000) return CALCUATE( sum('total data'[Abs Error Value Final]), ALL( 'total data' ), 'total data'[Calendar Year/Month] = selection )