Forum Discussion

Helper I

2 years ago

Solved

Slicer for certain values

I have a visualization that shows a comparison of certain values. There is a simple calculation like Value A * Value B = Result (in bars) I want a slicer like this that changes only few cert...

Need Help

Anonymous
2 years ago
Hi MurtoMan ,

The Table data is shown below:

Please follow these steps:
1. Use the following DAX expression to create a Table

Table 2 = GENERATESERIES(1,100,1)

2.Use the following DAX expression to create a measure

Result = VAR _a = SELECTEDVALUE('Table'[Item]) VAR _b = SELECTEDVALUE('Table'[Factor]) VAR _c = SELECTEDVALUE('Table'[Value]) RETURN IF( _a = "Shoes", DIVIDE(_b,100) * MAX('Table 2'[Value]) * _c , _b * _c )

3.Use the following DAX expression to create a measure

_Factor = IF( SELECTEDVALUE('Table'[Item]) = "Shoes", DIVIDE(SELECTEDVALUE('Table'[Factor]),100) * MAX('Table 2'[Value]),SELECTEDVALUE('Table'[Factor]))

4.Final output

Best Regards,
Wenbin Zhou
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
(5)2024.4.26.pbix30 KB

Anonymous

Not applicable

2 years ago

Hi MurtoMan ,

Regarding your question, this is my thought process.

The Table data is shown below:

Please follow these steps:

1.Add an index column to determine which values to modify with the slicer.

2.Use the following DAX expression to create a table

Table 2 = GENERATESERIES(0.00,1.01,0.01)

3.Use the following DAX expression to create a measure(Assuming that the index columns corresponding to the specific values to be modified are 1, 2, 3)

MEASURE =
VAR _a =
    MAX ( 'Table 2'[Value] )
VAR _b =
    IF (
        _a = CALCULATE ( MAX ( 'Table 2'[Value] ), ALL ( 'Table 2' ) ),
        SUM ( 'Table'[Value A] ) * SUM ( 'Table'[Value B] ),
        IF (
            SELECTEDVALUE ( 'Table'[Index] ) IN { 1, 2, 3 },
            _a
                * SUMX (
                    FILTER ( 'Table', 'Table'[Index] = SELECTEDVALUE ( 'Table'[Index] ) ),
                    'Table'[Value B]
                ),
            SUM ( 'Table'[Value A] ) * SUM ( 'Table'[Value B] )
        )
    )
RETURN
    _b

3.Final output

Displays the default value when the slicer has not made a selection.