Selected column function for measure

[Aruljoy]

Hi All,

I want to create a new data set based on existing using selected columns. 

Test1 = SELECTCOLUMNS(TransactionData,"MemberID",TransactionData[MemID],"FailOnlyFlag",COUNTROWS ( FILTER ( VALUES ( 'TransactionData'[MemID] ) , [Measure_SuccessCount] = 0 ) ))

[Measure_SuccessCount] = 

CALCULATE(countrows(TransactionData),FILTER(TransactionData,TransactionData[TransactionTypeDerived]="success"))

getting the following error ""

Can anyone help me how to achieve this?

[Anonymous · Accepted solution]

Hi @Aruljoy ,

Please try using below formula to create a new table.

test1 =
var _count = CALCULATE(countrows(TransactionData), FILTER(TransactionData, TransactionData[TransactionTypeDerived]="success"))
return
SELECTCOLUMNS(TransactionData, "MemberID", TransactionData[MemID], "FailOnlyFlag", calculate(COUNTROWS('TransactionData'), Filter(ALLEXCEPT(TransactionData, TransactionData[MemID]), _count=0)))

Best Regards,

Jay

[amitchandak]

@Aruljoy , This should be create as table, you are creating as measure

Test1 = SELECTCOLUMNS(TransactionData,"MemberID",TransactionData[MemID],"FailOnlyFlag",COUNTROWS ( FILTER ( VALUES ( 'TransactionData'[MemID] ) , [Measure_SuccessCount] = 0 ) ))

Slicer values will not work with calculated table , better create a var in measure

Test1 =

var _tab = SELECTCOLUMNS(TransactionData,"MemberID",TransactionData[MemID],"FailOnlyFlag",COUNTROWS ( FILTER ( VALUES ( 'TransactionData'[MemID] ) , [Measure_SuccessCount] = 0 ) ))

return

countrows(_tab)