how to restrict the data in powerbi to only some fileds.

[Harish85]

HI All,

 I am looking to limit the data in the table or result, I have report where it fetching all the values of both columns,now I am getting values of BUKRS -1038-EKORG all values(2401,2441,2402,w501,2421) ,But user  want to restrict the date as below

1038-2401 

1046- 2401 ( exclude all other values )

1563-2441( exclude other values) how to restrict that please help

LFB1_BUKRS LFM1_EKORG

1038	2401
1046	2401
1563	2441
1854	2402
1991	W501
1A21	2421

[v-saisrao-msft]

Hi @Harish85,

May I ask if you have resolved this issue? If so, please mark the helpful reply and accept it as the solution. This will be helpful for other community members who have similar problems to solve it faster.

Thank you.

[mdaatifraza5556]

Hi @Harish85 

Can you please try the below steps

Create a table using below dax 

   

FilteredTable =

FILTER (

    'Table',

    ('Table'[LFB1_BUKRS] = "1038" && 'Table'[LFM1_EKORG] = "2401") ||

    ('Table'[LFB1_BUKRS] = "1046" && 'Table'[LFM1_EKORG] = "2401") ||

    ('Table'[LFB1_BUKRS] = "1563" && 'Table'[LFM1_EKORG] = "2441")

)

If this answers your questios, kindly accept it as a solution and give kudos.

[v-saisrao-msft]

Hi @Harish85,

I wanted to check if you had the opportunity to review the information provided by @mdaatifraza5556 @bhanu_gautam . Please feel free to contact us if you have any further questions. If my response has addressed your query, please accept it as a solution and give a 'Kudos' so other members can easily find it.

Thank you.

[bhanu_gautam]

@Harish85 

You can create a new table manually in Power BI with the specific values you want to keep:

FilteredValues =
DATATABLE (
"LFB1_BUKRS", STRING,
"LFM1_EKORG", STRING,
{
{"1038", "2401"},
{"1046", "2401"},
{"1563", "2441"}
}
)

You can create a new calculated table that filters the main table based on the values in the FilteredValues table:

DAX
FilteredTable =
FILTER (
MainTable,
COUNTROWS (
FILTER (
FilteredValues,
FilteredValues[LFB1_BUKRS] = MainTable[LFB1_BUKRS] &&
FilteredValues[LFM1_EKORG] = MainTable[LFM1_EKORG]
)
) > 0
)

Now, you can use the FilteredTable in your report visuals instead of the original MainTable.