Forum Discussion

OSS's avatar
OSS
Helper III
7 years ago
Solved

Filtered result name

Hi Community I have problem with filtering the data. My data has customer ID, customer name, customer branch and a number of other dimensions. I use card visual for displaying these dimensions and...
Need Help
  • v-frfei-msft's avatar
    v-frfei-msft
    7 years ago

    Hi OSS ,

     

    To create three meausre to work on it.

    BranhM = 
VAR countrall =
    CALCULATE ( COUNTROWS ( 'Customer List' ), ALL ( 'Customer List' ) )
VAR countr =
    CALCULATE ( COUNTROWS ( 'Customer List' ), ALLSELECTED ( 'Customer List' ) )
RETURN
    IF ( countr = countrall, "All", MAX ( 'Customer List'[Branch] ) )

    Customer NameM = 
VAR countrall =
    CALCULATE ( COUNTROWS ( 'Customer List' ), ALL ( 'Customer List' ) )
VAR countr =
    CALCULATE ( COUNTROWS ( 'Customer List' ), ALLSELECTED ( 'Customer List' ) )
RETURN
    IF ( countr = countrall, "All", MAX ( 'Customer List'[Customer Name] ) )

    RMM = 
VAR countrall =
    CALCULATE ( COUNTROWS ( 'Customer List' ), ALL ( 'Customer List' ) )
VAR countr =
    CALCULATE ( COUNTROWS ( 'Customer List' ), ALLSELECTED ( 'Customer List' ) )
RETURN
    IF ( countr = countrall, "All", MAX ( 'Customer List'[RM] ) )

     

Ashish_Mathur's avatar
Ashish_Mathur
Super User
7 years ago

Hi,

Try this measure

=IF(HASONEVALUE(Data[Customer ID]),VALUES(Data[Client]),"All")

Hope this helps.