Forum Discussion
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 : Tr...
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.
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.Levajar its going to be hard to resolve this without the data, can you create sum dummy date that has similar values?
Here is the sample i could mimic it
