Forum Discussion

Aruljoy's avatar
Aruljoy
Helper II
4 years ago
Solved

Selected column function for measure

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?
Need Help
  • Anonymous's avatar
    Anonymous
    4 years ago

    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

2 Replies

  • amitchandak's avatar
    amitchandak
    Super User
    4 years ago

    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)

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    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