cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
osinquinvdm Regular Visitor
Regular Visitor

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 Requests = CALCULATE([Nb Requests];'311_Details'[Nature]<>"Information")
Nb Info Requests = CALCULATE([Nb Requests];'311_Details'[Nature]="Information")

How come the data now shows as aggregated, instead of getting broken down by Nature.

2017-03-17 16_29_26-311-dashboard - Power BI Desktop.png

The only change I made is to 

What coud explain such a a behaviour?

 

Thanks

1 ACCEPTED SOLUTION

Accepted Solutions
Sean Super Contributor
Super Contributor

Re: How come it is aggregating?

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/

4 REPLIES 4
Sean Super Contributor
Super Contributor

Re: How come it is aggregating?

Change the 1st measure to

Nb Requests = COUNT ( '311_Details'[DDS] )

 

osinquinvdm Regular Visitor
Regular Visitor

Re: How come it is aggregating?

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 Super Contributor
Super Contributor

Re: How come it is aggregating?

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 Regular Visitor
Regular Visitor

Re: How come it is aggregating?

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.

2017-03-20 14_12_03-311-dashboard - Power BI Desktop.png

Thanks again !

 

Helpful resources

Announcements
Back to School Contest

Back to School Contest

Engage and empower students with Power BI!

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Summit Australia 2019

Summit Australia 2019

Travel to Melbourne and network with thousands of peers!

Top Ideas
Users Online
Currently online: 279 members 3,064 guests
Please welcome our newest community members: