Use Parameter to Slice Aggregate Measure?
Hello all - Based off the below dataset, I have summed the 'daysonjob' column on my dashboard. Is there a way to filter or slice that aggregation based off a parameter within DAX? For example - If a parameter is selected as "all", I would like to see the sum of the entire column 'daysonjob'. If the parameter is selected as 'remove days off site,' I would like to see the sum of 'daysonjob' where 'laboronsite' = 'Y'. Essentially, I want the user to be able to select 'Days On Job' as all days the job has been active or only days where labor was actually on site. Is this possible? From my memory, this can be easily achieved in Tableau, but I can't seem to figure out how to write a DAX measure with parameters. Thanks in advance,
