Forum Discussion

sudhakar111's avatar
sudhakar111
Icon for Helper IV rankHelper IV
5 years ago
Solved

Comparing Values between tables

Hello All, I need some help with a requirement. I have 2 tables one is fact table and other is a reference table. The fact table is like the below table. Rep Name Place State City Date Produ...
Need Help
  • v-alq-msft's avatar
    v-alq-msft
    5 years ago

    Hi, sudhakar111 

     

    You may create a measure as below. The pbix file is attached in the end.

    Visual Control = 
IF(
    SUM('Fact'[Related])<SUM('Fact'[Value]),
    "red"
)

     

    Then you can set conditional format as below.

     

    Result:

     

    For further information, please refer to the following document.

    Use conditional formatting in tables 

     

    Best Regards

    Allan

     

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