How to show static column in matrix power bi

[Sudhakar1000]

HI,

Kindly help me the below,

I am trying to create Matrix , i have two table  Actual and customer

Actual is current year business done cases - in this Apple, Dell, HP, Lenovo OEM are there

Customer : Each region no customer in Count. 

First column : Region 

Second column : No Customer Available respactive Region,

Thired coulmn:  Looking how many customer is done business  in  apple or Dell, etc.

I need first two column to be fixed and 3 column is based on the slicer need to be change example if i select Apple then first two column is stable 3 column will show how many customer we have done Apple Business. attached image below

Looking Result. If select Apple first two column fixed , 3rd column will get change based product .

[Sudhakar1000 · Accepted solution]

Hi All,

 Now its working fine..

I have tried the below Measure..

= IF(ISBLANK(

CALCULATE(

    COUNTA('1200NamedSum'[SBUName]),

    '1200NamedSum'[SBUName] = SELECTEDVALUE('1200NamedSum'[SBUName])

)),0,CALCULATE(

    COUNTA('1200NamedSum'[SBUName]),

    '1200NamedSum'[SBUName] = SELECTEDVALUE('1200NamedSum'[SBUName])

))

[v-yohua-msft]

Hi, @Sudhakar1000 

Based on your information, I create sample tables:

Actual table

Customer table

Then create a new measure, try the following DAX expression:

SelectedProductCustomers = 
CALCULATE(
    COUNTROWS(Actual),
    Actual[Product] = SELECTEDVALUE('Actual'[Product])
)

Create a Slicer view and put Product in it, create a matrix visual, put Region and No Customer Available fields in it. Here is my preview:

When using the slicer, only the third column changes, and the first two columns are fixed. Power BI natively doesn't support pinning columns in matrix visualizations, but you can achieve a similar effect by carefully arranging the visualization and ensuring that slicers only affect dynamic columns.

How to Get Your Question Answered Quickly

Best Regards

Yongkang Hua

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Sudhakar1000]

Hi Yohua,

Thak you for  Quick Resonse, Here i have only Actal table.

No Of custimer i have taken count of S no ..

SBU Name as OEM Name

[elitesmitpatel]

Please shar dummy pbix file

[Sudhakar1000]

HI Elite,

Not allowing to share the File here

[elitesmitpatel]

@Sudhakar1000  just copy 10-20 column replace all the value with fake value and then share the file with mentioning expected output .