Dax referenced measures causes performance issues
Hi,
I have created a dax measure as below:
VT_Targetunitrate_2 =
SUMX ( Accruals, IF ( [Accrual cost source_2] = “Target”, [Switch Cost] ) )
I also tried using calculate but i am not able to apply the filter condition because [Accrual cost source_2] is a dax measure
FYI, Accrual Cost Source_2 & Switch cost in above dax code are both separate measures as below:
[Priority 1],[Priority 2] , [Priority 3] & Parameter Value cost are in turn referenced measures.
But this takes a lot of time to run in visual and its causing performance issues.
PFA file here Financial Management -Tanvi Trial.pbix
Can you please help how to improve performance as this is only a sample file with few million rows.
Please let me know if you need further info!
Thanks in advance!
Hi, I have created a dax measure as below: VT_Targetunitrate_2 =SUMX ( Accruals, IF ( [Accrual cost source_2] = “Target”, [Switch Cost] ) ) I also tried using calculate but i am not able to apply the filter condition because [Accrual cost source_2] is a dax measure FYI, Accrual Cost Source_2 & Switch cost in above dax code are both separate measures as below: [Priority 1],[Priority 2] , [Priority 3] & Parameter Value cost are in turn referenced measures. But this takes a lot of time to run in visual and its causing performance issues. PFA file here Financial Management -Tanvi Trial.pbixCan you please help how to improve performance as this is only a sample file with few million rows. Please let me know if you need further info! Thanks in advance!@SergeiBaklan Read More
