Particular action of slicer on matrix

[MHTANK]

Hello Experts,

this is my data

This is my report in power bi with matrix and slicerThis is my action in slicer and i get this matrix 

But i want this matrix

 

I mean the action of slicer is only on sale column data not on stock column data, I want whole stock data for particular Ref No.

Then how i do that?

[MHTANK]

Hello experts,

I am waiting for solution...

[ddpl]

@MHTANK try this

Create below measures :

Sales No = CALCULATE(SUM('Table'[No]),'Table'[Sales/Stock] = "Sale")

Sales Days = CALCULATE(AVERAGE('Table'[Days]),'Table'[Sales/Stock] = "Sale")

Stock No = CALCULATE(SUM('Table'[No]),'Table'[Sales/Stock] = "Stock",ALL('Table'[Date]))

Stock Days = CALCULATE(AVERAGE('Table'[Days]),'Table'[Sales/Stock] = "Stock",ALL('Table'[Date]))

Sum of No = [Sales No] + [Stock No] 

Ave of days = 
IF([Sales Days] == BLANK(), [Stock Days],
  IF([Stock Days] == BLANK() , [Sales Days],
  ([Sales Days] + [Stock Days])/2))

[MHTANK]

My solution is the last photo of my problem.

If I filter date from slicer I want a complete sale data for that filtered date, but in stock data I want a complete data without affecting by filtered date in same matrix.

[v-jingzhang]

Hi @MHTANK 

It's a little complicated. We need to create measures to realize this target and add some Dim tables to the model. As of now I get a result like below but haven't figured out how to filter out the highlighted ones. I will upload a whole sample file once I accomplished all. Hope it won't be too long. 

Best Regards,
Community Support Team _ Jing

[MHTANK]

Hello... you get solution?

[MHTANK]

Ok, I am waiting for your solution.