Forum Discussion
Helper IVComparing Values between tables
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.
Super Usersudhakar111 , related or related table can work depending on join type 1-M or M to1
refer if this video can helphttps://www.youtube.com/watch?v=Wu1mWxR23jU
or
Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.
Helper IVCreated a sample file. Here the values on the matrix have to be compared with the reference table values.If the values are greater than the reference table, those values have to be highlighted in red.
https://drive.google.com/file/d/1vlo4r-73T7TcohsehGp8jctn9S60bNKS/view?usp=sharing