How to sum a measure with one of the columns selected dynamically using slicer

[UmeshCR]

HI All,

Need your help urgently on a issue that i am facing. 

I have a table with different dimension columns such as DEPOT_REGION, DEPOT_SUBSI, DEPOT_NAME,etc. and a measure column.

The requirement is , i need to show the measure along with one of the dimension selected using the slicer.

I tried below things:

Created a manual table for stroing only the dimesnion names.

Then created a connecting table with key field from main table and dimension column from manual table.

Created a calculated measure on main table to get the dimension selected in the sclicer(used manual table dimension column for slicer). I am able to get the dimension selected in the slicer using the calculated measure.

But when i am bri ngingthis calculated mesure(selected dimnsion) with measure column from main table, the  measure column (main table) shows blank.

Regards,

UC

[v-lid-msft]

Hi @UmeshCR ,

Sorry for that, We cannot understand your data model clearly, Could you please provide a sample mockup table based on fake data or describle the fields of each tables and the relations between tables simply? Please don't have any Confidential Information or Real data in your reply.

Best regards,