Forum Discussion
Percentage Different from Excel and Power Bi
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.....
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.
amitchandak
Super User
Super UserAnonymous , 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.