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 Na...
Need Help
Show and Tell
  • Syk's avatar
    Syk
    1 year ago

    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
1 year ago

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.