Forum Discussion
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...
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] ) )
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] ) )
Thank you very much. It is exactly what I am looking for.
You are great!
Best Regards