DAX: Count on date filtering with a measure

[larabraghetti]

Dear All,

I hope someone can help me on this topic.

I have this Pivot Table:

Where:

• Values=The distinctcount is done on the column KEY=LIMLOGN[Id-Data]&LIMLOGN[SEGMDESC]
• Columns=[LvlCode]
• Rows=[Id-Data]

Then I wrote the following measure:

Stranges =
VAR LVL1 =
CALCULATE(DISTINCTCOUNT(LIMLOGN[KEY]);LIMLOGN[LvlCode] = 1)
VAR LVL2 =
CALCULATE(DISTINCTCOUNT(LIMLOGN[KEY]);LIMLOGN[LvlCode] = 2)
VAR LVL3 =
CALCULATE(DISTINCTCOUNT(LIMLOGN[KEY]);LIMLOGN[LvlCode] = 3)
VAR LVLTOT =
CALCULATE(DISTINCTCOUNT(LIMLOGN[KEY]))
RETURN
IF(
IF(AND(LVL1>LVL2;LVL1>LVL3);LVL1;
IF(LVL2>LVL3;LVL2;LVL3))<LVLTOT;
"Y";
"N"
)

All works fine. And I have built the following Pivot Table:

But now I need to filter the following table:

Anno=Year

Mese=Month

I need to count only if the measure is N.

Is it possible in some way?

Please, let me know if you need further information. 
Thank you in advance!!!
Lara

[Anonymous · Accepted solution]

Hi @larabraghetti,

You can use countax to get the count value of “N”:

Count of N = COUNTAX(FILTER('pivot Table',[Stranges]="N"),[Stranges] )

Screenshot:

 
If above is not help, can you provide the pbix file with some test data?

Regards,
Xiaoxin Sheng