Forum Discussion

Levajar's avatar
Levajar
Advocate II
7 years ago

Data is Off

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 ) )
Need Help

8 Replies

  • v-frfei-msft's avatar
    v-frfei-msft
    Community Support
    7 years ago

    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's avatar
      Levajar
      Advocate II
      7 years ago

      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's avatar
        vanessafvg
        Community Champion
        7 years ago

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

  • Levajar's avatar
    Levajar
    Advocate II
    7 years ago

    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..