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

Anonymous's avatar
Anonymous
Not applicable
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