Hello,
I have an issue in trying to make a dynamic calculated column that update when I select an option in my slicer (Yes/No or no option selected).
The Slicer
I have created a slicer, with the 2 options: Yes and No (no selection required, so this can also be "all").
The slicer defines whether the assets of my customers are part of my target market or not (this is based on multiple conditions to be met from several columns).
The Columns
My customers have 2 "kinds" of assets (the sum of these for each customer are given in 2 separate columns):
- 1 are the assets for which I have specific knowledge about (the majority of their assets) - this column interacts with the slicer already as these assets have the information to calculate their inclusion/exclusion of the target market (part of the same table as the target market calculation)
- 1 are the assets for which I do not have any specific knowledge about - I do not have any information about these that can let me include/exclude these from the target market, I only have a field stating the no of assets (coming from a different table than the other)
An example: Customer A has 80 known assets and 10 unknown assets = 90 assets in total
The Calculation
What I want to do is creating a column that:
- When no slicer option has been selected or the option is "no" the calculation should sum the no of known assets + the no of unknown assets (A + B = Total)
Ref. to Customer A it should be = 80 + 10 = 90
- When "yes" has been selected I want only the a sum of the known assets (A = Total)
Ref. to Customer A it should be 80 = 80
This means that the column containing the unknown assets should be adjusted to 0
