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

     

v-frfei-msft's avatar
v-frfei-msft
Community Support
7 years ago

Hi OSS ,

 

Could you please share your sample data and excepted result to me if you don't have any Confidential Information. Please upload your files to One Drive and share the link here.

 

  • 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