One number in measure vs filter context

[Marcin]

Hi,

i would like to create measure like :

DIVIDE ( SUM(Sales1[Amount]) ;  SUM(Sales2[Amount])  ; 0 ) - 1 

But I have a problem with filter/row context when use this measure in table per time becasue of -1. 

How to resolve that t? 

[v-danhe-msft]

Hi @Marcin,

Based on my test, your formula could work on my side:

What is your desired result?

Regards,

Daniel He

[Marcin]

HI @v-danhe-msft

The problem appears when the measure will be presented in time dimension :

Then I get all -1 vaules by all time day dimensions.

[Omega]

@Marcin 

It's either your totalsales is 0 at those dates, there is an issue in the formula TotalSales measure or the variance between TotalSales and TotalDiscount is very minimal (very close to zero). Try the below: 

• Check the totalSales formula
• Drag Date and TotalSales
• Change Test Measure data type to percentage

[v-danhe-msft]

Hi @Marcin,

I could not reproduce your problem, could you please share some sample data to have a test if possible?

Regards,

Daniel He

[Omega]

Please share sample data with expected results.