How to count oucomes of a measure

Anonymous · ‎09-22-2019

I have customers sales data of two years where I have used a mease to find in-active customers. A customer is In-Active if Sales Last Period (measure) is blank.

Sales Last Period = CALCULATE(

SUM('Chemist Daily Sales'[ValueDP]),

DATESINPERIOD('Calendar'[Date],

LASTDATE('Calendar'[Date]),

-1*[Period Value]*,

MONTH))

*Period Value can b 3, 6, or 9 months which is coming from What-if parameter.

I want to calculate how many customers were in-active and want to display the results in Card visual. Please Advise.

AnkitBI · ‎09-22-2019

Hi - If your measure Sales Last Period is returning correct values. Then you can use something like below.

-- DimProduct[EnglishProductName] - Replace with Customer Column

In Active Customer = countrows(filter(all(DimProduct[EnglishProductName]),isblank([Sales Last Period])))

Thanks
Ankit Jain

Do Mark it as solution if the response resolved your problem. Do like the response if it seems good and helpful.

Anonymous · ‎09-22-2019

Thanks for the reply. The measure you suggested is not giving the required result. Its counting all the blank rows in my sales table. I have used the following syntext.

In active customer count = COUNTROWS(FILTER(ALL('Daily Sales'[Customer Name]),ISBLANK([Sales Last Period])))

What I actually need is that when I select the In active period and the Distributor Name (slicers), the card visual should give me count of those stores which were in active.