Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Total Sum from New Measure

Hi Team,

 

I have done first table and get the Status ">90%" count , however I can't get the result in 2nd Table "Total status Sum".

 

 

Please advise me.

 

Thanks,

KV

Need Help
  • amitchandak's avatar
    amitchandak
    4 years ago

    Anonymous , a new measure

     

    sumx(addcolumns(summarize(Table, Table[Market], Table[ID]), "_1", [>90% count]) ,[_1])

1 Reply

  • amitchandak's avatar
    amitchandak
    Super User
    4 years ago

    Anonymous , a new measure

     

    sumx(addcolumns(summarize(Table, Table[Market], Table[ID]), "_1", [>90% count]) ,[_1])