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] ) )

     

OSS's avatar
OSS
Helper III
7 years ago

v-frfei-msft  I have uploaded the sample to one drive.

 

https://1drv.ms/u/s!Anq8qDsGb04laQas2uox-rnt5wE?e=GFu9BP

 

I visualise my data with the multiple row card. 

I want to write formula and make first row different untill some filter is applied. Actually I use this visual like one row visual and I want to write "ALL" for all dimensions untill definite filter is applied.

 

May be this is not possible with the multi row card visual. Then please advice me how can I achive this goal.

 

Best Regards

v-frfei-msft's avatar
v-frfei-msft
Community 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
    Helper III
    7 years ago

    Thank you very much. It is exactly what I am looking for. 

    You are great!

     

    Best Regards

  • OSS's avatar
    OSS
    Helper 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