powerbi - Power BI top gainers

Question

I would like to create a Matrix visualizing MOM top 10 gainer and decliner based transaction count for the respective customer account number across a specified period determined by a slicer.

Table: date, cus_acc_num, inv_num, MMYY

MMYY is a calculated field: EOMONTH('Table'[date],-1)+1

---

Measures:

TC = DISTINCTCOUNT('Table'[inv_num])

TC LM = CALCULATE(DISTINCTCOUNT('Table'[inv_num]),DATEADD('Table'[MMYY],-1,MONTH))

TC Var = DISTINCTCOUNT('Table'[inv_num]) - [TC LM]

Top 10 = CALCULATE([TC Var],FILTER(VALUES('Table'[cus_acc_num]),IF(RANKX(ALLSELECTED('Table'[cus_acc_num]),,[TC Var])<=10,[TC Var],BLANK())))

Please advise whether the above is correct as Power Bi kept loading without showing any result. Is there any other simplified method to show the above?

question from:https://stackoverflow.com/questions/65842639/power-bi-top-gainers

Answer 1

Waitting for answers