Combining dimensions instances based on slicer option within waterfall visual

[DSzcz]

Hey Guys, 

To simplify it: 

I have a fact table with keys to the dimensions and a column value, which is the measure of the value. 
Sales = SUM('FactTable'[value]) 

Fact table: 

DateKey	RunKey	TouchpointKey	Chann elKey	Value
20240220	20240220_01	1	1	100
20240220	20240220_01	2	2	100
20240220	20240220_01	3	3	100
20240220	20240220_02	1	1	100

Dim Touchpoint
TouchpointKey	Touchpointname
1	Base
2	Salesperson A
3	Salesperson B
4	SalesPerson C

What I need to replicate from Python app is to have such slicer by the waterfall chart where based on the criteria from that slicer, the data is added to the baseline touchpoint. 

Then I need to show the data by waterfall chart: 

But the tricky part is about the slicer. If you pick one of the objects from it, it shall be added to the baseline and this particular instance of Touchpoint dimension will not be displayed by the X- axis anymore. 
If you have a look against the visual above (Sales person A has a sales of 100). 
At the buttom visual this person was picked and the person disappeared from axis X and increased the value of baseline. 
The objects on X-axis are coming from one dimension. Same with the slicer. 

Do you have any idea how to deal with that? 
I tried setting up a mapping table but it didn't work when it comes to waterfall visual. 
Cheers! 

[DSzcz]

Hey @Anonymous , 
Thanks for your input. 
How would you procced if there could be more options picked by the slicer at once? 
Not olny single choice (this spoils the SELECTEDVALUE()) approach. 

Best wishes 

[Anonymous · Accepted solution]

Hi @DSzcz ,

Please have a try.

Adjusted Sales = 
VAR SelectedTouchpoint = SELECTCOLUMNS('Dim Touchpoint',"values",'Dim Touchpoint'[TouchpointKey])
RETURN
IF(
    SelectedTouchpoint = "All",
    SUM('FactTable'[value]),
    CALCULATE(
        SUM('FactTable'[value]),
        FILTER(
            'FactTable',
            'FactTable'[TouchpointKey] = "1" || 'FactTable'[TouchpointKey] = SelectedTouchpoint
        )
    )
)

How to Select Multiple Columns in Power BI - Zebra BI

How to Get Your Question Answered Quickly 

If it does not help, please provide more details with your desired output and pbix file without privacy information (or some sample data) .

Best Regards
Community Support Team _ Rongtie

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

Hi @DSzcz ,

Please refer to the posts.

Solved: How to write a DAX function when a Slicer value is... - Microsoft Fabric Community

Solved: Display selected slicer values(multiselect) - Microsoft Fabric Community

How to Get Your Question Answered Quickly 

If it does not help, please provide more details with your desired output and pbix file without privacy information (or some sample data) .

Best Regards
Community Support Team _ Rongtie

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[DSzcz]

I'm aware of that, thanks! 

So if we have a variable that stores all the slicers that were picked, then this particular measure is not gonna work. 
How would you adjust the part that is after FILTER function? 
Cheers

Adjusted Sales = 
VAR SelectedTouchpoint = SELECTEDVALUE('Dim Touchpoint'[TouchpointKey], "All")
RETURN
IF(
    SelectedTouchpoint = "All",
    SUM('FactTable'[value]),
    CALCULATE(
        SUM('FactTable'[value]),
        FILTER(
            'FactTable',
            'FactTable'[TouchpointKey] = "1" || 'FactTable'[TouchpointKey] = SelectedTouchpoint
        )
    )

[Anonymous]

Hi @DSzcz ,

Please have a try.

Create a measure.

Adjusted Sales = 
VAR SelectedTouchpoint = SELECTEDVALUE('Dim Touchpoint'[TouchpointKey], "All")
RETURN
IF(
    SelectedTouchpoint = "All",
    SUM('FactTable'[value]),
    CALCULATE(
        SUM('FactTable'[value]),
        FILTER(
            'FactTable',
            'FactTable'[TouchpointKey] = "1" || 'FactTable'[TouchpointKey] = SelectedTouchpoint
        )
    )
)

How to Get Your Question Answered Quickly 

If it does not help, please provide more details with your desired output and pbix file without privacy information (or some sample data) .

Best Regards
Community Support Team _ Rongtie

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.