Forum Discussion

osinquinvdm's avatar
osinquinvdm
Advocate II
9 years ago
Solved

How come it is aggregating?

I have requests that can be either service requests or information requests. I have the following 3 measures to count them:   Nb Requests = CALCULATE(COUNT('311_Details'[DDS])) Nb Service Reques...
Need Help
  • Sean's avatar
    Sean
    9 years ago
    Nb Info Requests =
CALCULATE (
    [Nb Requests];
    FILTER ( '311_Details'; '311_Details'[Nature] = "Information" )
)

Nb Service Requests =
CALCULATE (
    [Nb Requests];
    FILTER ( '311_Details'; '311_Details'[Nature] <> "Information" )
)

    osinquinvdm

    The way you had originally written these they had an implied ALL function

    FILTER ( ALL ( '311_Details'[Nature] )... => therefore ignoring any existing filter context!

    http://www.sqlbi.com/articles/filter-arguments-in-calculate/

osinquinvdm's avatar
osinquinvdm
Advocate II
9 years ago

sorry about that.

I just applied that simplification but as expected it does not make a difference.

How do I get NB DDI to show 0 on all lines except information?

Sean's avatar
Sean
Community Champion
9 years ago
Nb Info Requests =
CALCULATE (
    [Nb Requests];
    FILTER ( '311_Details'; '311_Details'[Nature] = "Information" )
)

Nb Service Requests =
CALCULATE (
    [Nb Requests];
    FILTER ( '311_Details'; '311_Details'[Nature] <> "Information" )
)

osinquinvdm

The way you had originally written these they had an implied ALL function

FILTER ( ALL ( '311_Details'[Nature] )... => therefore ignoring any existing filter context!

http://www.sqlbi.com/articles/filter-arguments-in-calculate/

  • osinquinvdm's avatar
    osinquinvdm
    Advocate II
    9 years ago

    Thank you so much.

    I had no idea that not using an explicit FILTER() function would actually result in using an implicit ALL() function.

    The small tweak you recommended made all the difference.

    Thanks again !