Forum Discussion

curiouspbix0's avatar
curiouspbix0
Helper IV
5 years ago
Solved

Dax Aggregation Issue

  Hello Daxers,   Running into an aggregation here, first table shows raw data, second table is the dax measure which computes correctly when Status column is not used in the table. Actual is s...
Need Help
Show and Tell
  • Anonymous's avatar
    Anonymous
    5 years ago

    Hi curiouspbix0 ,

    You can create a measure as below:

    Actual =
CALCULATE (
    SUM ( 'TableVehicle'[Vehicle Count] ),
    FILTER ( 'TableVehicle', 'TableVehicle'[Status] IN { "Running", "Active" } )
)

    Best Regards

Singaravelu_R's avatar
Singaravelu_R
Resolver III
5 years ago

In modeling click Net Table (write a dax expression to create new table) and write summarize DAX as per blow screenshot,