Forum Discussion
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 help to achieve this.
8 Replies
@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))hi amitchandak thanks for the reply. Actually they are all Caluclated Colomns based on DateDiff(Weeks).
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 , These T1, t2 members are column or dimension members.
What is the format of the raw data. please share example
