Forum Discussion
DAX Perfromance Issue
Hi All, I m using below measures to get Top 20% from vendor list. Top_20%_Vendor = IF (ISBLANK ( [Invoiced] ),BLANK (),IF ([Ranking]< ( CALCULATE ( [Unique_Vendor], ALL ( f6MonthSpend ) ) * 0.2 ...
Hi Anonymous ,
Would you please try to use IF instead of switch in your TOPN?
TopN =
IF (
[SelectedTOPNValue] = 0,
[Invoiced],
IF ( [Ranking] <= [SelectedTOPNValue], [Invoiced] )
)
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Best Regards,
Dedmon Dai