Share via

Need help resolving a DAX calculation error in Power Pivot

Anonymous
2023-06-02T23:06:42+00:00

Hi,

With one of my DAX formulas in Power Pivot, I'm getting an error saying, "Too few arguments were passed to the ALL function. The minimum argument count for the function is 1." I cannot figure out what exactly is causing this, so any help is much appreciated. The formula is: %OfGrandTotal:=DIVIDE([TotalSales($)],CALCULATE([TotalSales($)],ALL()))

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2023-06-03T02:45:32+00:00

    Hello Joseph,

    I'm Ibhadighi and I'd happily help you with your question. In this forum, we are Microsoft consumers just like yourself.

    The error message you’re seeing indicates that the ALL function in your formula is missing an argument. The ALL function requires at least one argument to specify the column, table or other expression for which you want to remove context filters. In your formula, it appears that the ALL function is being called without any arguments.

    You can try modifying your formula to include an argument for the ALL function. For example, if you want to remove context filters from a column named ColumnName, you could modify your formula to be: %OfGrandTotal:=DIVIDE([TotalSales($)],CALCULATE([TotalSales($)],ALL(ColumnName)))

    Please let us know if you need more help.

    Best Regards, IBHADIGHI

    Was this answer helpful?

    1 person found this answer helpful.
    0 comments
  2. Ashish Mathur 102.1K Reputation points Volunteer Moderator
    2023-06-02T23:57:39+00:00

    Hi,

    Try this

    =%OfGrandTotal:=DIVIDE([TotalSales($)],CALCULATE([TotalSales($)],ALL(Data[Product])))

    Was this answer helpful?

    0 comments