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"
)
Syk's avatar
Syk
Resident Rockstar
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"
)