Percentage Different from Excel and Power Bi

[Anonymous]

Hi,

I don't know what I'm doing wrong but the excel sheet is showing the correct percentage but when i done it with power bi but it  showing different value or Nan.

Any advise???

Thanks...tksnota

Excel

Power Bi

[amitchandak · Accepted solution]

@Anonymous , If Pecentage is measure and used in row, than it will work. But if is row value then you need ignore visual row filter

if( Max(Table[Column] ) = "Percent", calculate([Percent Formula], all(Table[Column]) ) , [Other formula] )

First measure sum(Margin)/ sum(Sales) is correct and should work.