Slicer by brand

[mekaelj]

Hi,

I have several measures where I can see for example sales quantity based on the different brands of my business. The total sales quantity is connected to two other queries where I have data that helps me separate the different brands.

My measures look like this:

Qty Product 1 = CALCULATE(SUM(Sales[SalesQty]);Dim_Items[Product group]="group1";Dim_Items[Brand]="Brand1")

Qty Product 2 = CALCULATE(SUM(FactSalesInvoiceLines[SalesQty]);Dim_Items[Product group]="group2";DimOptions[Brand]="Brand2")

So as you can see I have to get data from both dimoptions and dim_items to be able to differentiate between the products. Now, I want to create a slicer where I can sort the items based on brand. Seeing as I get my brands from two different queries, I don't know how to do this. Do I merge them all into on query somehow and then create a slicer through that? I tried doing so but when I then created my slicer and sorted by brand it didn't actually filter at all. Clearly I've gone wrong somewhere along the way.

Cheers

[v-sihou-msft · Accepted solution]

@mekaelj

If you want to use a slicer to filter both "Brand1" and "Brand2", you have to union two queries into one. You can achieve it via either DAX or Power Query.

Reference:
UNION Function (DAX)

Table.Combine

Regards,