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 ;and then used this as the criteria for an if statnement,Please Login or Register to view this content.
,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?
Bookmarks