Limit filter to be applied only on one column

[Islam]

Hello Experts

I'm working on developing a dynamic excel file reports using power pivot and dax and I'm facing an issue to create a certain Dax Measure specially applying special filters in the table

it's simple kinda but for me as a beginner it's hard so if anyone here willing to start a zoom meeting for me and take control over my file to create that required measure i would be very grateful

Thx Everyone

like it's shown in the last picture i see very total every where

those are the two pictures and i need column value for ZAVANA to be repeated as a total ZAVANI Transactions to use it later to Generate some portions and indicators no matter what is shown in the visual

[AllisonKennedy]

@Islam  You can get the actual value simply by using the pivot table filters, but to get % share you could try: 

Total Revenue = SUM(TotalRevenue[Pouring Amount])

Then you can use teh [Total Revenue] measure to get subtotal and grand totals.

For example:

Total Revenue ALL Clients = CALCULATE( [Total Revenue], ALL(TotalRevenue[Client])

Revenue as % of All Clients = DIVIDE ( [Total Revenue], [Total Revenue ALL Clients] )

Just change what you put inside the ALL() function to change how you calculate the %