Forum Discussion
filter using two columns
it would probably make sense to calculate a new table to handle this. The table will have two columns, Corporate and SalesPerson :
Slicer Table =
UNION (
SELECTCOLUMNS (
FILTER( 'Table' , 'Table'[Corporate] <> BLANK() ) ,
"Source" , 'Table'[Source] ,
"Selection" , 'Table'[Corporate]
),
SELECTCOLUMNS (
FILTER ( 'Table' , 'Table'[Salesperson] <> BLANK() ) ,
"Source" , 'Table'[Source] ,
"Selection" , 'Table'[SalesPerson]
)
)
After this has been calculated, create a relationship between these tables, between the Source columns. Since this is purely for filtering the table on the person of interest, make it be Many-to-Many and have Slicer Table filter Table:
Create a slicer with the Selection column from the Slicer Table and test the functionality:
Good afternoon! I need to know the total amount I have of "Yes, "TRUE", "yes" in the RESTULT column. STATUS. For this, you need to filter the column, how? After that I need to use a measure to know the amount I have of "Yes, "TRUE", "yes".
Hi,
If you wish to count the Yes/true in the Result column, then write this measure
Measure = calculate(countrows(Data),Data[Result]="Yes"||Data[Result]="true")
My assumption is that true is text true (not a boolean true).
Hope this helps.
