+ Reply to Thread
Results 1 to 1 of 1

DAX RANKX Top N values by slicer error

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

    DAX RANKX Top N values by slicer error

    Workbook attached.
    Hi,
    I have ranked some figures and then used an IF statement to bring back the top 3 ,

    Please Login or Register  to view this content.

    I then used a selected value TopN = 1,2,3,4 ;
    Please Login or Register  to view this content.
    and then used this as the criteria for an if statnement,


    Please Login or Register  to view this content.
    ,

    this works fine if I have selected a value from the slicer, but if I have not selected anything
    I would like all the values to show, which is why I used [Tunits] for the false resut in oneV measure.
    The problem is the bottom 4 values do not show if no selection is made?
    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. DAX RANKX totals
    By Dicken in forum Office 365
    Replies: 0
    Last Post: 03-30-2023, 09:53 AM
  2. RankX based on Slicer selection in PowerPivot
    By hansolu in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 09-19-2021, 10:43 AM
  3. 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
  4. Power BI RANKX
    By ibuhary in forum Excel General
    Replies: 0
    Last Post: 10-23-2018, 07:05 AM
  5. Loop through slicer, but don't do slicer action when values are unselected
    By as_sass in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 05-08-2018, 04:55 PM
  6. Loop through slicer, while also selecting single slicer value on separate slicer
    By as_sass in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 04-30-2018, 01:41 PM
  7. Replies: 1
    Last Post: 04-23-2018, 09:43 AM

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