Data is Off

[Levajar]

When i use function to display UP/DOWN arrow with thresholds/conditional formatting - the relationship is getting lost & data is OFF. What could be the solution to resolve this ? 

Formula : 

Trend =

VAR Down =

UNICHAR ( 11167 )

VAR Up =

UNICHAR ( 11165 )

VAR Side =

UNICHAR ( 11166 )

RETURN

IF ( 'Table1'[% Metric1] < 0, Up, IF ( 'Table1'[% Metric2]> 0.1, Down, Side ) )

[v-frfei-msft]

Hi @Levajar ,

I think [% Metric1]and [% Metric2] should be measures here. Could you please share the formula of them? BTW, please share your sample data to me if you don't have any Confidential Information. Please upload your files to One Drive and share the link here.

[Levajar]

@v-frfei-msft  Yes, those are measures

here you go with formula

% Metric 2 = DIVIDE(SUM(Table2[Numerator]),SUM(Table2[Denominator]),0) 

Numerator = Table2[Col1] - Table2[Col2]

Please review and advise. Unfortunately, it has sensitive data and hence, couldn't share the pwbx file here. 

[vanessafvg]

@Levajar  its going to be hard to resolve this without the data, can you create sum dummy date that has similar values?

[Levajar]

Here is the sample i could mimic it 

https://hcahealthcare-my.sharepoint.com/:u:/r/personal/pho7659_hca_corpad_net/Documents/Documents/Sa...

[vanessafvg]

@Levajar  I will look at home tonight.

[v-frfei-msft]

Hi @Levajar ,

I cannot access the file you shared. Could you please share it again ?

[Levajar]

@vanessafvg  any changes for you to look at that one drive document. Please advise. 

[Levajar]

Please let me know if someone has any idea why the data will be off (i.e.) relationships are not working while using functions. 

USERELATIONSHIP() not sure if that will resolve - i tried & it didn't.. 

So looking for some expert advise..