Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Dynamic Table - Part 3 adding TAU Value

Hi Experts   1 m referring to the folloiwing Kendall's Tau Quick Measure here: https://community.powerbi.com/t5/Quick-Measures-Gallery/Kendall-s-Tau/m-p/625107.   This is a calculation that ws cr...
Need Help
  • Anonymous's avatar
    Anonymous
    7 years ago
    New table =
FILTER (
    ADDCOLUMNS (
        VALUES ( PMS_COMPLAINT[FISCAL_MON_START_DT] ),
        "CountComplaints", CALCULATE ( COUNTROWS ( PMS_COMPLAINT ) ),
        "__Index", RANKX ( PMS_COMPLAINT, PMS_COMPLAINT[FISCAL_MON_START_DT],,, DENSE )
    ),
    [FISCAL_MON_START_DT] <> BLANK ()
)
parry2k's avatar
parry2k
Super User
7 years ago

Anonymous link to Quick Measure is not working, can you repost to check what is it and how it can be used in your model.

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Hi Perry2k

 

The answer lie with the greg decker link on how you can implement the measure....he uses two variables and sorts the data interviewer 1 and 2. I want to implement the same principles with my data using variables as I mentioned in above post...

 

I have created a table called table in the new link (new file uploaded), i am trying to create measures for Concordant and Discordant as greg did and then work out the Tau.

See Table in new link below

My Index column is my FISCAL_MON_START_DT

and My interviewer 2 is my Material_ID 

 

So far i have (which is not correct)

Tau = 
VAR Mytable = ADDCOLUMNS(VALUES(PMS_COMPLAINT[FISCAL_MON_START_DT]),"CountComplaints", CALCULATE(COUNTROWS(PMS_COMPLAINT)))
VAR __table1 = ADDCOLUMNS(Mytable,"__Concordant",COUNTROWS(FILTER(Mytable,[FISCAL_MON_START_DT]>EARLIER([FISCAL_MON_START_DT])&&[CountComplaints]>EARLIER([CountComplaints]))))
VAR __table2 = ADDCOLUMNS(__table1,"__Discordant",COUNTROWS(FILTER(Mytable,[FISCAL_MON_START_DT]>EARLIER([FISCAL_MON_START_DT])&&[CountComplaints]<EARLIER([CountComplaints]))))

VAR __C = SUMX(__table1,[__Concordant])
VAR __D = SUMX(__table2,[__Discordant])

RETURN

ABS(DIVIDE(__C - __D , __C + __D,0))

It's not a quick measures answer.

see new file https://www.dropbox.com/s/jizl49iyw6pkg2p/Sample__%281%29.pbix?dl=0

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago
    New table =
FILTER (
    ADDCOLUMNS (
        VALUES ( PMS_COMPLAINT[FISCAL_MON_START_DT] ),
        "CountComplaints", CALCULATE ( COUNTROWS ( PMS_COMPLAINT ) ),
        "__Index", RANKX ( PMS_COMPLAINT, PMS_COMPLAINT[FISCAL_MON_START_DT],,, DENSE )
    ),
    [FISCAL_MON_START_DT] <> BLANK ()
)