Forum Discussion

SimonAbs's avatar
SimonAbs
Frequent Visitor
8 years ago
Solved

Calculate(Count (....), (Datesbetween(....)) returns nothing

Hey guys :)

 

I insert the following Measure in Power BI Desktop:

 

Latest_NPS = CALCULATE(COUNTA(NPS[nps_category]);DATESBETWEEN(NPS[ts];[LastestDate_NPS_Start];[LatestDate_NPS_End]))

 

It retunrs: Nothing

 

Returns_Nothing

 

If I insert this measure:

 

Latest_NPS = CALCULATE(COUNTA(NPS[nps_category]);DATESBETWEEN(NPS[ts];[LastestDate_NPS_Start];[LastestDate_NPS_Start]))

 

It retunrs: 1

1

 

Why I am not able to COUNTA the NPS[nps_category] for a specific timeline?

 

Thanks in advance,

Simon 

 

 

Need Help
  • Anonymous's avatar
    Anonymous
    8 years ago

    Hi SimonAbs,

     

    You can try to use below formula to calculate records between specific date range:

    Latest_NPS =
VAR currStart =
    MAX ( NPS[LastestDate_NPS_Start] )
VAR currEnd =
    MAX ( NPS[LatestDate_NPS_End] )
RETURN
    CALCULATE (
        COUNTA ( NPS[nps_category] );
        FILTER ( ALLSELECTED ( NPS ); NPS[ts] IN CALENDAR ( currStart; currEnd ) )
    )

    Regards,
    Xiaoxin Sheng

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    Hi SimonAbs,

     

    You can try to use below formula to calculate records between specific date range:

    Latest_NPS =
VAR currStart =
    MAX ( NPS[LastestDate_NPS_Start] )
VAR currEnd =
    MAX ( NPS[LatestDate_NPS_End] )
RETURN
    CALCULATE (
        COUNTA ( NPS[nps_category] );
        FILTER ( ALLSELECTED ( NPS ); NPS[ts] IN CALENDAR ( currStart; currEnd ) )
    )

    Regards,
    Xiaoxin Sheng

    • SimonAbs's avatar
      SimonAbs
      Frequent Visitor
      8 years ago

      Hi Anonymous,

       

      Thanks for the fast reply.

      It works perfect :)

       

      Best regards,

      Simon