Forum Discussion

Chandrashekar's avatar
Chandrashekar
Icon for Resolver III rankResolver III
4 years ago
Solved

Slicer : Values not reflecting

Hello,   I have two slicers(Week No & Region). when I select region individually values not getting reflected in Card(Visiual). However am getting correct value when I select ALL in region(Slicer)...
  • PabloDeheza's avatar
    PabloDeheza
    4 years ago

    The function ALL is preventing for filters to be applied to the measure, so using VALUES instead of ALL would allow this to happen. It should look this way:

    SUMX(
    Summarize('TS','TS'[Pri],'TS'[As]),
    CALCULATE (
    COUNTROWS('TS'),USERELATIONSHIP('TS'[DCS],'Calendar'[Date]),
    FILTER (
    VALUES('TS'), 'TS'[Parent]=Blank() && 'TS'[InTa2] =1 &&
    'TS' [Response/Restore]<>Blank()),
    'TS'[Pri]=earlier('TS'[Pri]),
    'TS'[As]=EARLIER('TS'[As]
    )))+0

Chandrashekar's avatar
Chandrashekar
Icon for Resolver III rankResolver III
4 years ago

Hello,

 

Yes region belongs to table TS. Could you please help me with Dax as not understood how to replace ALL with values.

 

Regards,

Chandrashekar B

PabloDeheza's avatar
PabloDeheza
Icon for Solution Sage rankSolution Sage
4 years ago

The function ALL is preventing for filters to be applied to the measure, so using VALUES instead of ALL would allow this to happen. It should look this way:

SUMX(
Summarize('TS','TS'[Pri],'TS'[As]),
CALCULATE (
COUNTROWS('TS'),USERELATIONSHIP('TS'[DCS],'Calendar'[Date]),
FILTER (
VALUES('TS'), 'TS'[Parent]=Blank() && 'TS'[InTa2] =1 &&
'TS' [Response/Restore]<>Blank()),
'TS'[Pri]=earlier('TS'[Pri]),
'TS'[As]=EARLIER('TS'[As]
)))+0

  • Chandrashekar's avatar
    Chandrashekar
    Icon for Resolver III rankResolver III
    4 years ago

    Hello,

     

    Thanks it is working fine.

     

    Regards,

    Chandrashekar B