Forum Discussion

makarama's avatar
makarama
Frequent Visitor
1 year ago
Solved

Calculate does not evaluate properly - data is missing

The following Dax Expression returns 3 but the table has 55 under the same exact conditions.
 
Service Availability Last Month cr list = calculate(count(wcr_ops_MonitorTSOAvail[Service Offering Name]),wcr_ops_MonitorTSOAvail[Service Offering Name] = "CA Calagry Network Services", wcr_ops_MonitorTSOAvail[Availability Type] = "Daily")
 
 
 
What am I doing wrong?
No relevant filters are applied.
  • To understand what the issue is, can you provide some of your data? 

    Also posting this here for readability:

    Service Availability Last Month cr list =
    CALCULATE (
        COUNT ( wcr_ops_MonitorTSOAvail[Service Offering Name] ),
        wcr_ops_MonitorTSOAvail[Service Offering Name] = "CA Calagry Network Services",
        wcr_ops_MonitorTSOAvail[Availability Type] = "Daily"
    )

4 Replies

  • Syk's avatar
    Syk
    Resident Rockstar

    To understand what the issue is, can you provide some of your data? 

    Also posting this here for readability:

    Service Availability Last Month cr list =
    CALCULATE (
        COUNT ( wcr_ops_MonitorTSOAvail[Service Offering Name] ),
        wcr_ops_MonitorTSOAvail[Service Offering Name] = "CA Calagry Network Services",
        wcr_ops_MonitorTSOAvail[Availability Type] = "Daily"
    )
  • v-echaithra's avatar
    v-echaithra
    Community Support

    Hi makarama ,

    As we haven’t heard back from you, we wanted to kindly follow up to check if the solution provided for the issue worked? or Let us know if you need any further assistance?
    If our response addressed, please mark it as Accept as solution and click Yes if you found it helpful.

     

    Regards,
    Chaithra.

  • v-echaithra's avatar
    v-echaithra
    Community Support

    Hi makarama ,

    We wanted to kindly follow up to check if the solution provided for the issue worked? or Let us know if you need any further assistance?
    If our response addressed, please mark it as Accept as solution and click Yes if you found it helpful.

     

    Regards,
    Chaithra.

  • v-echaithra's avatar
    v-echaithra
    Community Support

    Hi makarama ,

    As we haven’t heard back from you, we wanted to kindly follow up to check if the solution provided for the issue worked? or Let us know if you need any further assistance?
    If our response addressed, please mark it as Accept as solution and click Yes if you found it helpful.

     

    Regards,
    Chaithra.