Forum Discussion

cj_oat's avatar
cj_oat
Helper I
1 year ago

Value missing from Matrix table after using SUMX

Hi guys,   I'm trying to create Measure to count other Measure based on conditions below,   Qualified Flag Count = VAR _ActiveFlag = if ([ActiveFlag]>0 , 1 , BLANK()) VAR _SalesInv = if ([Cum...
Need Help
Anonymous's avatar
Anonymous
Not applicable
1 year ago

Hi ,

Based on the description, try to create a table that includes the dates you need. Try using the following DAX formula.

Qualified Flag Count =
VAR _ActiveFlag = IF([ActiveFlag] > 0, 1, 0)
VAR _SalesInv = IF([Cumulative Sales] + [Inventory] > 0, 1, 0)
VAR _QualifiedFlag = IF(_ActiveFlag + _SalesInv = 2, 1, 0)
RETURN
SUMX(
    CALENDAR(MIN('Table'[Date]), MAX('Table'[Date])),
    _QualifiedFlag
)

 

Best Regards,

Wisdom Wu

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

cj_oat's avatar
cj_oat
Helper I
1 year ago

Hi Anonymous 

 

it still shows blank, I guess it's because I do not have data rows in source data table for those in June and July month...