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
