Forum Discussion

Ben83's avatar
Ben83
Icon for Advocate IV rankAdvocate IV
10 years ago
Solved

Text field to show the selected filter

I have created a report for the delivery reliability of our company. In this report I imported a long excel list with all of our delivery positions of a whole year. Every single delivery positions is...
Need Help
  • konstantinos's avatar
    konstantinos
    10 years ago

     You can try a measure that return text. You need to add it in a table , matrix or card visual.

     

    1. If you have a client column/table with unigue clients you can try this

     

    Clients Filtered =
IF (
    HASONEVALUE ( Clients[ClientName] );
    VALUES ( Clients[ClientName] );
    "ALL"
)

    2. If not you, you filter from fact table or other this option should work

    Clients Filtered 2 =
IF (
    COUNTROWS ( VALUES ( Sales[Client] ) ) = 1;
    VALUES ( Sales[Client] );
    "ALL"
)

    Hope that helps

     

     

konstantinos's avatar
konstantinos
Icon for Memorable Member rankMemorable Member
10 years ago

MP_123 which one didn't work 1,2 or 3 version. Now I see that 3 don't work, it should be similar to 

Clients Filtered 3 =
SWITCH (
 TRUE;
 AND(ISFILTERED ( Client[ClientName] );COUNTROWS ( VALUES ( Client[ClientName] ) ) )= 1; VALUES ( Client[ClientName] );
 AND(ISFILTERED ( Client[ClientName] );COUNTROWS ( VALUES ( Client[ClientName] ) )) > 1; CONCATENATE ( COUNTROWS ( VALUES ( Client[ClientName] ) ); " Clients" );
 "ALL"
)

 

The other two one should work fine. I think you sould try one of the first two and replace "ALL" with BLANK()

 

If it doesn't work can you write some more details regarding the tables involed as the formula also?

 

 

Jayanth's avatar
Jayanth
Regular Visitor
8 years ago

Hi,

 

I have to show 'ALL' as test field, when I select the drop down Age limit as Multi select like 30,50 and 60 it should show as the same or if I choose Select All it should display in text field as ALL.

 

I used the below code, it works only for Single select not for Multi select, please help me...

 

AFILTER = If(HASONEFILTER('UVN_CNSMR_CORE MSTR_CNSMR_PRFL'[AGE]),
VALUES ('UVN_CNSMR_CORE MSTR_CNSMR_PRFL'[AGE]),"ALL")

AFILTER = If(HASONEFILTER('UVN_CNSMR_CORE MSTR_CNSMR_PRFL'[AGE]),
    VALUES ('UVN_CNSMR_CORE MSTR_CNSMR_PRFL'[AGE]),"ALL")