cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
v-ljerr-msft Super Contributor
Super Contributor

Re: Summary Error with IF Statement

Hi @aminw0u,

 

According to your descriptions above, you may need to firstly summarize your data at [Generic SKU Name] level, then use SUMX to get the correct total in your scenario. The formula below is for your reference. Smiley Happy

08.a Expired Release via Scrap =
SUMX (
    SUMMARIZE (
        EEORE,
        EEORE[Generic SKU Name],
        "abc", IF ( [01. Expired PQ] < [07. Gross Scrap], [01. Expired PQ], [07. Gross Scrap] )
            * -1
    ),
    [abc]
)

 

Regards

aminw0u Frequent Visitor
Frequent Visitor

Re: Summary Error with IF Statement

I think it makes sense to summarize, but when I do that, it gives me an answer that is even more incorrect than before unfortunately. Smiley Sad The 08.3 column is the one that includes the summarize formula.

 

08.e Expired Release via Scrap =
SUMX (
SUMMARIZE (
EEORE,
EEORE[Generic SKU Name],
"abc", IF ( [01. Expired PQ] < [07. Gross Scrap], [01. Expired PQ], [07. Gross Scrap] )
* -1
),
[abc]
)

 

 

Summarize.PNG

Helpful resources

Announcements
Virtual Launch Event

Microsoft Business Applications October Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

Power BI Helps Homeless and Trouble Youth

Power BI Helps Homeless and Trouble Youth

We spoke with Power BI Super User, Greg Deckler, about his charity work

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Users Online
Currently online: 235 members 2,714 guests
Please welcome our newest community members: