Home Forums Power Pivot error if change filter

Tagged: 

This topic contains 9 replies, has 2 voices, and was last updated by  tomallan 2 months, 4 weeks ago.

Viewing 10 posts - 1 through 10 (of 10 total)
  • Author
    Posts
  • #9768

    benibeno
    Participant
    • Started: 2
    • Replies: 6
    • Total: 8

    Hi,

    I’ve been using PP for 2 weeks now.

    I’ve loaded Excel data and created a pivot table.

    When a use a filter everything is fine. But when I try removing it I get this error.

     

    Any Idea where I went wrong ?

    Thanks

    Attachments:
    You must be logged in to view attached files.
    #9774

    tomallan
    Keymaster
    • Started: 7
    • Replies: 2461
    • Total: 2468

    It has happened to me before that when clearing (removing) a filter, the greater dataset introduced a division by zero.

    Instead of using the division operator (“/”), try using the DIVIDE() function, which handles division by zero without raising an error.

    Let me know if that made a difference.

    Also, if you could run the text of your message through google translate, that could help also. Otherwise I can just understand the part that reads like there was a syntax error.

    #9954

    benibeno
    Participant
    • Started: 2
    • Replies: 6
    • Total: 8

    Hi Tom,

    I tried your method but no success.

    Here my translation of the error:
    Syntax is incorrect.. All the rest of the error is in English.

    “Affaires” is the filter I’m using.
    Don’t know if that helps !

    Thanks

    #9960

    tomallan
    Keymaster
    • Started: 7
    • Replies: 2461
    • Total: 2468

    The list of measures in the original images do not show a measure where Affaires (?Business) is used.

    Is it used in a slicer or part of a formula?

    #9979

    benibeno
    Participant
    • Started: 2
    • Replies: 6
    • Total: 8

    Here is my list of measures. Hopefully it will help!

    Thanks

     

    Attachments:
    You must be logged in to view attached files.
    #9983

    tomallan
    Keymaster
    • Started: 7
    • Replies: 2461
    • Total: 2468

    What I do not know is how you are using Affaires, whether in a slicer or if you are working with cube formulas.

    Can you put up some sample data in a workbook?

    Some of your field names are missing a table prefix, such as [Transfer eligible]. Since this appears to happen consistently with [Transfer eligible], my reaction is that you are referencing a measure, but since it is not listed separately as its own calculation in your list of measures, it must be a column. However, the point here I want to make is sometimes when a table reference is not used with a column in a formula an error can be generated.

    #10073

    benibeno
    Participant
    • Started: 2
    • Replies: 6
    • Total: 8

    Hi,

    I tried adding table prefix as you can see in image attached.

    I’m using some formulas in columns and then using thoses new columns in my measures. I don’t know if that can be part of the problem?

    Attachments:
    You must be logged in to view attached files.
    #10075

    tomallan
    Keymaster
    • Started: 7
    • Replies: 2461
    • Total: 2468

    Not enough information in images alone.

    If you do not have time to create a workbook with demo data, at least one other option is to contact our paid help desk. Yes, there will be a charge but you will have an answer without sending a workbook to a public forum.

    Best regards,

    Tom

    #10085

    benibeno
    Participant
    • Started: 2
    • Replies: 6
    • Total: 8

    Hi,

    Apparently the problem was in the name of the columns.

    Ligne d’affaires was problematic because of the ” ‘ “. Renamed it ligne_affaires and works out fine.

    Thanks

    #10087

    tomallan
    Keymaster
    • Started: 7
    • Replies: 2461
    • Total: 2468

    Pleased to read of your success!

    Tom

Viewing 10 posts - 1 through 10 (of 10 total)

You must be logged in to reply to this topic.