Forum Discussion

Marit's avatar
Marit
Helper II
6 years ago
Solved

Using dynamic slicers with multiple measures behind each category

Hi!

 

I'm trying to create at dynmic slicer with disconnected tables, adding different measures to my line plot.  I have used a dax syntax which worked fine when i only have one measure for each category. However, when i trided to add multiple measures I got no errors, but still no measures is in my plot when I select the category. I tried like this:

 

Kgfor_Foredlingskyllingvalg = VAR LOGICTEST= COUNTROWS(DISTINCT(FILTER(ALLSELECTED('ValgTypeProduksjon'[Type Produksjon]); ValgTypeProduksjon[Type Produksjon] = "Foredlingskylling"))) = 1
RETURN
IF( LOGICTEST;
[Kgfor_Foredlingskylling]
|| [Kgfor_Foredlingskyllingfilter;
BLANK() )
 
Is to possible to have two or more measures behind the category I select in the slicer?
 
Regards Marit
 
Need Help

1 Reply

  • v-chuncz-msft's avatar
    v-chuncz-msft
    Community Support
    6 years ago

    Marit 

     

    A measure can only return a single result. Multiple measures need to be added separately.