Forum Discussion

harshagraj's avatar
harshagraj
Post Partisan
6 years ago

To count max in row

Hi all i need to display as higlighted on the Image. Here the total unique count of Tools are 5.  Eg Count of T1 will be 2 Because  D & E are at T1 and Count of T4 is 1 because A is at T4.  Kindly ...
Need Help
amitchandak's avatar
amitchandak
Super User
6 years ago

@harshagraj , These T1, t2 members are column or dimension members.

What is the format of the raw data. please share example

From now on I can think

if it's measures

_t1 distinctCOUNT(Table[T1])
_t2 distinctCOUNT(Table[T2])
table table _t3 table in the table of different characteristics table([T3])

and more

then treat as
calculatecalculate(countx(values(Table[tool]),_t1),filter(Table, isblank(_t2) && isblank(_t3))

  • harshagraj's avatar
    harshagraj
    Post Partisan
    6 years ago

    hi amitchandak thanks for the reply. Actually they are all Caluclated Colomns based on DateDiff(Weeks).

    • amitchandak's avatar
      amitchandak
      Super User
      6 years ago

      Then something like this

      calculate(countx(values(Table[tool]),_t1),filter(Table, isblank(_t2) && isblank(_t3))

       

      or this should work

      countx(filter(summarize(Table,Table[tool], "_t1" , distinctCOUNT(Table[T1]), "_t2" , distinctCOUNT(Table[T2])
      , "_t3" , distinctCOUNT(Table[T3]) ,, "_t4" , distinctCOUNT(Table[T4])),
      isblank([_t2]) && isblank([_t3]) && isblank([_t4])),[_t1])

      • harshagraj's avatar
        harshagraj
        Post Partisan
        6 years ago

        hi amitchandak  thank you for the responce. Pleases help me i am totally confused andunable to replicate the formula below. Please tell me if it is a Calculated Measure or Column. Actual Table name is PPR and Column names are Tool Number and Date Diff column names are T0,T1,T2,T3 & T4.