+ Reply to Thread
Results 1 to 1 of 1

DAX RANKX totals

  1. #1
    Forum Contributor
    Join Date
    08-03-2021
    Location
    London
    MS-Off Ver
    365
    Posts
    594

    DAX RANKX totals

    I have a rankx measure which when used on it's own ranks the Grand total as 1, order desc. ,
    but when I add the Total Unfits measure even though the grand total is still ranked 1 so is the highest value in the collumn,

    I have this hard coded and controlled by a slicer to give various top N values. I've attached the workbook with two pivots one for the slicer,]and the other
    showing the two Ranks of one?

    I would just like some guidance on what's happening, and also if I just had the ranking, is there way in power pivot to 'turn off' including the grand total?
    I've tried isfilered but not got it right.

    Richard.
    Attached Files Attached Files

+ 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. RankX based on Slicer selection in PowerPivot
    By hansolu in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 09-19-2021, 10:43 AM
  2. How to create a pivot table/chart with both daily totals and running totals
    By plasteredric in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 07-14-2020, 07:23 PM
  3. Replies: 6
    Last Post: 03-06-2020, 04:53 PM
  4. How do you do a RANKX calc in DAX properly?
    By tbucki1 in forum Excel General
    Replies: 0
    Last Post: 08-05-2019, 01:15 PM
  5. Power BI RANKX
    By ibuhary in forum Excel General
    Replies: 0
    Last Post: 10-23-2018, 07:05 AM
  6. Pivot Table Percentage of grand totals listed under the grant totals
    By Biker102 in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 05-31-2017, 01:31 PM
  7. [SOLVED] running totals in Pivot Table - removing a user from the totals for the current week
    By eisenbergg in forum Excel Charting & Pivots
    Replies: 12
    Last Post: 09-08-2013, 04:39 PM

Tags for this Thread

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