Forum Discussion

anandav's avatar
anandav
Skilled Sharer
6 years ago
Solved

Help with ALL function

Hi Experts,   I have the following measure: Customer subset = Var vAG = DISTINCT( SELECTCOLUMNS(FILTER(ALL(Sales), MONTH(Sales[Sale Date]) IN ALLSELECTED('Analysis Group Calendar'[Month])), ...
Need Help
  • v-juanli-msft's avatar
    v-juanli-msft
    6 years ago

    Hi anandav 

    I create a measure which show the same result as your Customer subset measure when there is no relationship among tables.

    Measure =
CALCULATE (
    DISTINCTCOUNT ( sales[sale cust] ),
    FILTER (
        ALL ( sales ),
        sales[sale date] <= MAX ( 'filter date table'[Date] )
            && sales[sale date] >= MIN ( 'filter date table'[Date] )
    )
)

     

    Also this measure won't change with the slicer from "calendar[date]".

    Best Regards
    Maggie
    Community Support Team _ Maggie Li
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
v-juanli-msft's avatar
v-juanli-msft
Community Support
6 years ago

Hi anandav 

I create a measure which show the same result as your Customer subset measure when there is no relationship among tables.

Measure =
CALCULATE (
    DISTINCTCOUNT ( sales[sale cust] ),
    FILTER (
        ALL ( sales ),
        sales[sale date] <= MAX ( 'filter date table'[Date] )
            && sales[sale date] >= MIN ( 'filter date table'[Date] )
    )
)

 

Also this measure won't change with the slicer from "calendar[date]".

Best Regards
Maggie
Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
  • anandav's avatar
    anandav
    Skilled Sharer
    6 years ago

    v-juanli-msft ,

    Thanks a lot for the help and really appreciate it. That works perfectly. :smileyhappy: