Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
1 year ago
Solved

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

 

Excel

 

Power Bi

 

 

 

Need Help
  • amitchandak's avatar
    amitchandak
    1 year ago

    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.

1 Reply

  • amitchandak's avatar
    amitchandak
    Icon for Super User rankSuper User
    1 year ago

    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.