Include/Exclude fields used in calculation which in turn is used in a measure

[KojakWeb]

Hi,

I have a calculated field (total salary) which is made up of several pay elements (e.g. gross salary, car allowance, pension contribution, pension contribution, etc., etc.). This calculated field is used in a measure to determine the gender pay gap. I would like to create a report that will allow to dynamically select/deselect one or more of these pay elements to see what the impact would be on the gender pay gap during a presentation.

I did try to use parameters for each pay element, and using that value in the formula for the calculated field, but to no avail. So any help would be much appreciated.

A.

[Eric_Zhang · Accepted solution]

@KojakWeb

You can reference my demo as below. See more details in the attached pbix file. If it is not your case, please post more details of your scenario.