Create 2 Measures from 2 different slicers

[Sai_Alkesh]

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

[parry2k]

@Sai_Alkesh you have to have two seperate dimension table to achieve this and then you can use respective dimension in your mesure.

[Sai_Alkesh]

@parry2k 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.

[parry2k]

@Sai_Alkesh what is your measure? Can you share?

[Sai_Alkesh]

@parry2k 

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 name

Abs 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 2

Sorry 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
)

[Sai_Alkesh]

@parry2k 

the formula works, however i get wrong values:

the Abs final values for 

Jan 19 are 7.03M

Feb 19 are 7.88M

When i select Jan 19 in slicer 1, i get the correct value of 7.03M

However, when i select Feb 19 in Slicer 2, the measure returns to me value of 179.37M..... this should just be 7.88M

[parry2k · Accepted solution]

@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

[Sai_Alkesh]

@parry2k 

Thanks, Yes i do have other filters wherein am filtering by Geography (Region, Country, Market etc.,)

I changed ALL to ALLSELECTED and the 2nd measure works fine. However the first slicer selections are gone when i select the 2nd slicer....

I'll try to send you the link for the pbix download...maybe am doing something silly in here...

Thanks for all your help !

[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) ?