DAX formula nested measures

[shophoney]

Hi I have 3 measures. They all work fine on their own. But now I would like to have it evaluate when all 3 conditions are met.

I cant seem to get it to work.

MUGS UNITS SOLD:=CALCULATE([SALES TOTAL UNITS SOLD],('tblInvSkuMaster'[<wbr>brand_code]="CANA10"))

MUGS TRANS# DISTINCT COUNT:=CALCULATE(DISTINCTCOUNT<wbr>('SALES TABLE'[TRANS#]),'SALES TABLE'[UNITS SOLD]>0,tblInvSkuMaster[brand_<wbr>code]="CANA10")-CALCULATE(DIST<wbr>INCTCOUNT('SALES TABLE'[TRANS#]),'SALES TABLE'[UNITS SOLD]<0,tblInvSkuMaster[brand_<wbr>code]="CANA10")

MUGS RETAIL:=CALCULATE([SALES TOTAL NET RETAIL])

I would like the formula to evaluate if MUGS UNITS SOLD"1, MUGS TRANS# DISTINCT COUNT=1 AND MUGS RETAIL

thanks

 

[EZeeXLR]

This is a great question, I am also looking to find a way to display only the transactions where units sold on the transaction are greater than 2 for a specific model. Would an If/And nested dax formula work?

Any help would be much appreciated

 

[shophoney]

This is a great question, I am also looking to find a way to display only the transactions where units sold on the transaction are greater than 2 for a specific model. Would an If/And nested dax formula work?

Any help would be much appreciated

Hi, Ezee.

I did some testing last night and I think that might be the right direction.

I will try to test again. But our company is very busy right now and my days are limited.

Maybe a power user might have an idea to help.

Cheers