Need help with Measure

[NavaneethaRaju]

Hi,

I need the measure for comparing measure resultant values like the condition. 

Tag ID	Set ID	Set Description	System	Tag Owner	Order Owner	Usage Type	No. Of Procedures	Total Procedures	% Of Usage
1221	924.902	REV	REV Ti	JP	JP	Used	48	50	96%
1221	924.902	REV	REV Ti	JP	TS	Shared	2	50	4%

My requirement:

I nead to create a flag in No of procedures, to differentiate Used and Shared values like this.
Only if shared procedure is greated than used procedures, i need to show green flag over there, else i need to show red flag.
I'm dont know about compare the measure resultant values.

U = CALCULATE(

[No of Procedures],'Tag Usage Fact'[Usage Type]="Used")

S = CALCULATE(

[No of Procedures],'Tag Usage Fact'[Usage Type]="Shared")

Comp(U&S) = IF([U]<[S],1,0)

I wrote a measure like this but result not coming correct.

Please advice how to compare this values.

[v-zhangti · Accepted solution]

Hi, @NavaneethaRaju 

There is nothing wrong with your method, the formula needs to be modified a little.

U = CALCULATE([No. Of Procedures], FILTER(ALL('Tag Usage Fact'),[Usage Type]="Used"))

S = CALCULATE([No. Of Procedures],FILTER(ALL('Tag Usage Fact'),[Usage Type]="Shared"))

Comp(U&S) = IF([U]<[S],1,0)

Is this the result you expect?

Best Regards,

Community Support Team _Charlotte

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