Doesn't show value in the subtotal but show in each cell? Would you help to guess why?

[naoyixue1]

Hey there,

I'm having a issue that one measure works at cell level, but not subtotal level. Do you know why? I really have no idea where I need to check and fix. Thanks (see below table) But even I put that measure in the table, it still doesn't show anything. Do you know why? really no idea what I should check to fix. Thanks!

[naoyixue1]

By the way, I add the new measure to catch the unit price, See below. Since right now, one finished goods SKU might have to SKU, one is sub SKU and the other is original SKU. 

Below is the way for me to catch the finished goods SKU level shortage. But it doesn't work in subtotal (missing and incorrect) 

[V-lianl-msft · Accepted solution]

Hi @naoyixue1 ,

You can try the HASONEFILTER function:

Measure = IF(HASONEFILTER(Table[SKU]),
IF(xxxxxxxx>=0,BLANK(),SUMX(VALUES(XXXX),XXX*XXX)),
SUMX(VALUES(XXXX),XXX*XXX)
)

Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[naoyixue1]

@ribisht17 and the others,

The purpose here is to show the shortage by production line in $, See below two steps

1: Calculate the SKU level difference between forecast and prouction in units

2: Applied the unit price to convert the difference in units to dollars

Originally, I was ok.  But we have some subSKUs under the initial SKU list (see below), and related production is only located in those sub SKUs, not the finished SKU. Given that, I just added another column to catch only finished goods, which helps to understand the finished goods SKU level difference between forecast and production.  

Please see my original measure of Shortage in dollars, it was ok, because I got everything from column SKU

Right now, I just changed measure to catch the different under finished goods SKU level, which already removed or converted the subSKU to the finished goods SKU. In the details level, it was ok, but I didn't see the top level subtotal which is missing, and on top of that, the aggregation is not right. (see below) 

Exp 1: I see the detailed level shortage, but the subtotal is missing

Exp 2  Even the detail level is right, but the subtotal is not right. 

I think something might be wrong when I calculate  the shortage $, even the SKU level is correct. Do you have any thoughts? Thanks!

[ribisht17]

Need sample data/pbix

Ritesh

Mark my post as a solution if it helped you| Munde and Kudis (Ladies and Gentlemen) I like your Kudos!! !!
My You Tube Channel !! Connect on Linkedin