Forum Discussion

raphazzz's avatar
raphazzz
Icon for Helper I rankHelper I
3 years ago
Solved

Calculate table is showing more rows than expected.

Friends, I created a calculated table with information from another table but applying some filters. But when I apply the same filters to the source table, I have different row counts. ...
Need Help
  • johnt75's avatar
    johnt75
    3 years ago

    You're missing a comma, and you've got a bracket in the wrong place.

    WIP - Service Count Table =
SELECTCOLUMNS (
    FILTER (
        SalesReport,
        SalesReport[Status] <> "Canceled"
            && SalesReport[Active] = "Yes"
            && SalesReport[Subscription] IN { "QUARTERLY", "BIMONTHLY", "MONTHLY" }
    ),
    "Customer ID", SalesReport[Customer ID],
    "Branch", SalesReport[Office],
    "Subs", SalesReport[Subscription],
    "Contract", SalesReport[Contract],
    "Date Sold", SalesReport[Date Sold],
    "Initial Service", SalesReport[Initial Service Date]
)
raphazzz's avatar
raphazzz
Icon for Helper I rankHelper I
3 years ago

I tried it but I'm getting an error now. Would you mind explaining it?

WIP - Service Count Table = 
SELECTCOLUMNS (
    FILTER (
        SalesReport,
       SalesReport[Status]<> "Canceled" 
            && SalesReport[Active] = "Yes"
            && (SalesReport[Subscription] IN { "QUARTERLY", "BIMONTHLY", "MONTHLY" }
    )
    "Customer ID", SalesReport[Customer ID],
    "Branch", SalesReport[Office],
    "Subs", SalesReport[Subscription],
    "Contract", SalesReport[Contract],
    "Date Sold", SalesReport[Date Sold],
    "Initial Service", SalesReport[Initial Service Date]
))

 

 



johnt75's avatar
johnt75
Icon for Super User rankSuper User
3 years ago

You're missing a comma, and you've got a bracket in the wrong place.

WIP - Service Count Table =
SELECTCOLUMNS (
    FILTER (
        SalesReport,
        SalesReport[Status] <> "Canceled"
            && SalesReport[Active] = "Yes"
            && SalesReport[Subscription] IN { "QUARTERLY", "BIMONTHLY", "MONTHLY" }
    ),
    "Customer ID", SalesReport[Customer ID],
    "Branch", SalesReport[Office],
    "Subs", SalesReport[Subscription],
    "Contract", SalesReport[Contract],
    "Date Sold", SalesReport[Date Sold],
    "Initial Service", SalesReport[Initial Service Date]
)