Comparing values of two measures

Question

Hi Community,&nbsp;&nbsp;I am looking to do a simple compare of two measures to show Sales target progress against the elapsed time in a month and return a 1 if target is higher and a 0 if lower than target.&nbsp; I am then hoping I can use conditional formatting and use the numbers to return icons to illustrate whether we are on track or not to potentially meet our targets.&nbsp;So for example&nbsp;&nbsp;% Target Complete% Elapsed Time of monthComparisonBrand A55%50%1Brand B45%50%0&nbsp;I know this should be quite simple but so far have been unable to get this to work.&nbsp; &nbsp;Any further ideas appreciated,&nbsp;&nbsp;thanks&nbsp;MT&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;

mwegener · Accepted Answer

Comparison = IF([% Elapsed Time of month] &gt; [% Target Complete], 1, 0)&nbsp;Please give Kudos for support.If I answered your question, please mark my post as solution, this will also help others.

Forum Discussion

Comparing values of two measures

2 Replies

Related content

Measure returning incorrect value

Comparing measure and column value

Comparing column values with measure

Measure to compare values

Compare measure value over two dates

	% Target Complete	% Elapsed Time of month	Comparison
Brand A	55%	50%	1
Brand B	45%	50%	0