Forum Discussion

OSS's avatar
OSS
Icon for Helper III rankHelper 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] ) )

     

v-frfei-msft's avatar
v-frfei-msft
Icon for Community Support rankCommunity Support
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] ) )

 

OSS's avatar
OSS
Icon for Helper III rankHelper III
7 years ago

dear v-frfei-msft 

I have one more question related with this issue.

Taking into consideration the same sample, I want to add one another dimension. I want to add  'Country' dimension which ic connected with my main table via 'Branch' dimension. While adding 'Country' it returns the same input for every selection.

 

BranchCountry
New Smyrna Beach (US)US
Saguenay (CA)CA
Amersham (UK)UK
Sweetwater (US)US
Stratford (CA)CA
Neenah (US)US
Chichester (UK)UK
Prairie du Chien (US)US
Vancouver (US)US
Houghton Regis (UK)UK
Snodland (UK)UK
Grand Haven (US)US
Cedar Falls (US)US