Countif measure is below 0

[percy83]

Hi,

I am a beginner to DAX and got stuck on what would be a simple thing to solve in Excel.

I have the following measures

Trend sales =

CALCULATE([Total sales CC];

FILTER(dStoreInfo;

MAX(dDate[Date]) - dStoreInfo[Opening Date] - 365 - [Selected trend range] >= 0);

FILTER(dDate;

dDate[Date] > MAX(fSalesDataRunning36[Date]) - [Selected trend range] && dDate[Date] <= MAX(fSalesDataRunning36[Date]))

)

Trend bench sales =

CALCULATE([Trend sales];SAMEPERIODLASTYEAR(dDate[Date]))

Trend variance sales % = DIVIDE([Trend sales]-[Trend bench sales];[Trend bench sales];BLANK())

What I would like to do is count how many of  "Trend variance sales %" is less than 0

It should be easy right?! 

Thanks in advance! 

[Ashish_Mathur · Accepted solution]

Hi,

Does this help?

=CALCULATE(COUNTROWS(dStoreInfo),FILTER(dStoreInfo,[Trend sales]>0))

[parry2k]

@percy83 you COUNTX function to calculate # of counts.