Forum Discussion

CJ_96601's avatar
CJ_96601
Helper V
2 years ago

Lookup Value

Below table refers:     Company  Year 1 Year 2 Year 3 Option 1 3.00% 3.50% 4.50% Option 2 5.00% 6.50% 7.00% Option 3 4.00% 4.50% 5.50%   How to create measure (lookup ...
Need Help
Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi, CJ_96601 

 

Based on your description, I have created some measures to achieve the effect you are looking for. Following picture shows the effect of the display.

 

Convert the chart format to this:


Excel-like visual effects can be realized using a matrix:

The final result:

Measure:

 

getValue =

VAR SelectedYear =

    SELECTEDVALUE ( 'Year'[year] )

VAR SelectedCompany =

    SELECTEDVALUE ( 'company'[company] )

RETURN

    CALCULATE (

        SUM ( 'Table'[Value] ),

        'Table'[Year] = SelectedYear

            && 'Table'[Company] = SelectedCompany

    )

 


Best Regards,
Yang
Community Support Team

 

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly --  How to provide sample data in the Power BI Forum