We are developing a Data Model for Project Control. One of the Query, when we use for one day, is works but quite slow, Below is the Snapshot from DAX Studio
When We are using over Calendar; it is very slow and not usable.
Below is the DAX Query: Each measure is referring to many Measures,
%age Progress Actual:=DIVIDE (
VALUES( dMEDRDoc[Doc No] ),
[MH Actual Cutoff MEDR] * [%age Prog based on Return date] / 100
ALL ( ProjectCalendar ),
ProjectCalendar[Date] <= MAX ( ProjectCalendar[Date] )
[Total MH Based on MEDR]
Cheers!! Soni, + 66 852434420
@SanjeevSoni , Check if there ate bi-direction joins. Try to 1 to Many single directional joins.
What are formula of these two
[MH Actual Cutoff MEDR] , [%age Prog based on Return date]
is there an opportunity to make this as a calculated column? -[MH Actual Cutoff MEDR] * [%age Prog based on Return date]
it will move part of the cost to data loading,
Thanks, I shall prepae the data files and share .
Also I am exploring if I can move the some of the complex measure to Calculated Columns or get in mode using Power Query
I have some DAX Performance Tuning articles here:
These are also good articles:
Sorry for the link spam but it's a broad topic and the information you have provided is limited. Couple specific comments. First, I don't like VALUES. Second, is there any way you can limit the use of ALL and use ALLEXCEPT potentially or REMOVEFILTERS or KEEPFILTERS? I question the use of a SUMX within a CALCULATE statement, that seems redundant/unnecessary but hard to say.
Can you post sample source data and expected output?
Thanks for taking your time to providing the Links and other suggesstions.
Earlier I was knowing only maqsoftware.com link all other refereces and infomraiton quite usefull.
Let me review the measure and prepare the data to share with you.
Thanks once again
Click here to read more about the December 2021 Updates!
Don't miss the User Group Leader meetings on January, 24th & 25th, 2022.
Mark your calendars and join us for our next Power BI Dev Camp!