+ Reply to Thread
Results 1 to 2 of 2

PowerPivot DAX: Adjusting formula to show the value on all cells.

  1. #1
    Forum Contributor
    Join Date
    03-12-2014
    Location
    Riyadh
    MS-Off Ver
    Office 365
    Posts
    129

    PowerPivot DAX: Adjusting formula to show the value on all cells.

    Hello friends, Hope all is well!
    Please look at the image. The last column has the formula: =CALCULATE(SUM([VALUE]),FNDB[Name]=" Revenue")

    As you can see it works, but I want the formula to be adjusted to show the “ Revenue” result applied on all cells; i.e. blanks to be
    Filled with the Revenue result on all the cells that relate to the data of Branch and year.

    Please help me; and thank you so much in advance!
    Attached Images Attached Images

  2. #2
    Forum Contributor
    Join Date
    03-12-2014
    Location
    Riyadh
    MS-Off Ver
    Office 365
    Posts
    129

    Re: PowerPivot DAX: Adjusting formula to show the value on all cells.

    Hello friends, I think I got it. in case anyone faces the same challenge. Here is the formula:


    =CALCULATE(sum(fndb[value]), FILTER( fndb, fndb[year]= earlier(FNDB[year])&&fndb[branch]=earlier(FNDB[branch])&&fndb[name]=" Revenue") )

    All the Best!

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Help with adjusting formula so it does't calculate/display till all cells are filled in
    By littlered136 in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 10-15-2018, 03:51 AM
  2. adjusting a cells formula based on different input in another cell
    By cnak in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 05-25-2017, 07:16 PM
  3. PowerPivot 2010 > show all items with no data
    By stevemkiidub in forum Excel General
    Replies: 0
    Last Post: 01-14-2016, 04:29 PM
  4. [SOLVED] Powerpivot formula to show value that appears most in a column
    By AlexandraT in forum Excel Charting & Pivots
    Replies: 8
    Last Post: 03-13-2015, 11:23 AM
  5. PowerPivot - Show Actual OR Budget
    By Radovan in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 09-04-2014, 10:44 AM
  6. Show last 5 weeks in powerpivot
    By aftabn10 in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 01-23-2014, 10:51 AM
  7. Excel 2007 : Show column width label when manually adjusting
    By RichWhitUTB in forum Excel General
    Replies: 3
    Last Post: 11-22-2010, 05:31 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1