filter by brand, but not by brand

[pani_victoria]

Hello! Please, need help!

I have 2 tables, they are linked by ID.
I need to get a table that will show the sales of all Brands, where the BrandFolders is the same as the selected Brand.

[Ashish_Mathur]

Hi,

I have solved a similar problem in the attached file.

Hope this helps.

[Ahmedx · Accepted solution]

Based on your description, I created data to reproduce your scenario. The pbix file is attached in the end.

https://1drv.ms/u/s!AiUZ0Ws7G26RilEzzrIAb4-H2GLg?e=rKuktf

[pani_victoria]

I duplicate the formula here:

Create Slicer = VALUES(DIRECTORY[Brand])
and then create a measure
Final = VAR _selectBrand = VALUES( Slicer[Brand] )

VAR _SelectBrandFolder =

    SELECTCOLUMNS(

        FILTER( ALL( DIRECTORY ), DIRECTORY[Brand] IN _selectBrand ),

        "Folder", DIRECTORY[BrandFolder]

    )

RETURN

    CALCULATE( [Amo], KEEPFILTERS( _SelectBrandFolder ) )

[pani_victoria]

Many thanks, good man! You helped me a lot! 🤓

[devesh_gupta]

Create a DAX measure that calculates the sales for the selected Brand like:

SelectedBrandSales =
CALCULATE(
SUM(Sales[Sales]),
FILTER(ALL(Directory), Directory[BrandFolders] = SELECTEDVALUE(Directory[BrandFolders]))
)

Then you can create a table visual to display the sales.

[pani_victoria]

Your solution was also useful, but later 🙂 Thanks!