Need help for improving my dax

Question

Hello everyone,&nbsp;I have 2 table below :Table 1:&nbsp;&nbsp;Table 2:&nbsp;&nbsp;Table 2 is explained below :&nbsp;Condition :1.% New Std PD and Re open vs Target &gt;= 90%2.If % New Student PD vs New Enrol PD Target &lt; 80% , the bonus will be lowered by 1 level ( Note : If the New Student PD vs New Enrol PD Target is smaller than 80% and the bonus at level 1, the bonus will not be received)3.If % New Student PD vs New Enrol PD Target &lt; 80% and Campus code is Group 6 or Group 7, the bonus will be lowered by 1 level (Note : If the New Student PD vs New Enrol PD Target is smaller than 80% and the bonus at level 1, the bonus will not be minus 500,000)&nbsp;Example 1:Campus NCT has :% New Std PD and Re open vs Target = 103%% New Student PD vs New Enrol PD Target = 75%Bonus of Campus NCT (belong Group 2 ) is level 2: 9,000,000 ( with % New Std PD and Re open vs Target =103%) . However, because % New Student PD vsa New Enrol PD Target is smaller than 80% , so the bonus will be lowered by 1 level . The bonus will be level 1 =7,000,000&nbsp;Example 2:Campus BD-BCMb has:% New Std PD and Re open vs Target = 98%% New Student PD vs New Enrol PD Target = 50%Bonus of Campus BD-BCM (belong Group 6) is level 1 : 3,000,000 ( with % New Std PD and Re open vs Target =98%) . However, because % New Student PD vsa New Enrol PD Target is smaller than 80% , so the bonus will be : 2,500,000&nbsp;Here is my dax :&nbsp;Bonus Campus =VAR&nbsp;NewstdPD&nbsp;=&nbsp;SUM&nbsp;(&nbsp;'Campus'[# of New Student PD]&nbsp;)VAR&nbsp;TargetNewStdPD&nbsp;=&nbsp;SUM&nbsp;(&nbsp;'Campus'[# of New Enrol PD Target]&nbsp;)VAR&nbsp;pct_stdvstarget&nbsp;=&nbsp;DIVIDE&nbsp;(&nbsp;NewstdPD,&nbsp;TargetNewStdPD&nbsp;)VAR&nbsp;new_std_pd_reopen_pct&nbsp;=&nbsp;SELECTEDVALUE&nbsp;(&nbsp;'Campus'[% New Std PD And Re Open vs Target]&nbsp;)VAR&nbsp;new_std_pd_new_enrol_pct&nbsp;=&nbsp;SELECTEDVALUE&nbsp;(&nbsp;'Campus'[% New Student PD vs New Enrol PD Target]&nbsp;)VAR&nbsp;CampusCode&nbsp;=&nbsp;SELECTEDVALUE&nbsp;(&nbsp;Campus[Campus Code]&nbsp;)VAR&nbsp;CurrentGroup&nbsp;=&nbsp;SELECTEDVALUE&nbsp;(&nbsp;Bonus[Group]&nbsp;)&nbsp;VAR&nbsp;BonusLevel&nbsp;=&nbsp; &nbsp;&nbsp;SWITCH&nbsp;(&nbsp; &nbsp; &nbsp; &nbsp;&nbsp;TRUE&nbsp;(),&nbsp; &nbsp; &nbsp; &nbsp;&nbsp;new_std_pd_reopen_pct&nbsp;&gt;=&nbsp;1.1,&nbsp;3,&nbsp; &nbsp; &nbsp; &nbsp;&nbsp;new_std_pd_reopen_pct&nbsp;&gt;=&nbsp;1.0,&nbsp;2,&nbsp; &nbsp; &nbsp; &nbsp;&nbsp;new_std_pd_reopen_pct&nbsp;&gt;=&nbsp;0.9,&nbsp;1&nbsp; &nbsp; )VAR&nbsp;Bonus_campus&nbsp;=&nbsp; &nbsp;&nbsp;LOOKUPVALUE&nbsp;(&nbsp; &nbsp; &nbsp; &nbsp;&nbsp;'Bonus'[Bonus ],&nbsp; &nbsp; &nbsp; &nbsp;&nbsp;'Bonus'[Campus],&nbsp;CampusCode,&nbsp; &nbsp; &nbsp; &nbsp;&nbsp;'Bonus'[Level ],&nbsp;BonusLevel,&nbsp; &nbsp; &nbsp; &nbsp;&nbsp;'Bonus'[Group],&nbsp;CurrentGroup&nbsp; &nbsp; )RETURN&nbsp; &nbsp; &nbsp; &nbsp;&nbsp;IF(new_std_pd_new_enrol_pct&nbsp;&lt;&nbsp;0.7,&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;BLANK(),&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;IF(&nbsp;new_std_pd_new_enrol_pct&nbsp;&gt;=&nbsp;0.8,&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;Bonus_campus,&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;IF&nbsp;(&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;new_std_pd_new_enrol_pct&nbsp;&lt;&nbsp;0.8&nbsp;&amp;&amp;&nbsp;BonusLevel&nbsp;=&nbsp;3&nbsp;&amp;&amp;&nbsp;CurrentGroup&nbsp;=&nbsp;1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ||&nbsp;new_std_pd_new_enrol_pct&nbsp;&lt;&nbsp;0.8&nbsp;&amp;&amp;&nbsp;BonusLevel&nbsp;=&nbsp;3&nbsp;&amp;&amp;&nbsp;CurrentGroup&nbsp;=&nbsp;2,&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;MAX&nbsp;(&nbsp;0,&nbsp;Bonus_campus&nbsp;-&nbsp;6000000&nbsp;),&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;IF&nbsp;(&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;new_std_pd_new_enrol_pct&nbsp;&lt;&nbsp;0.8&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &amp;&amp;&nbsp;BonusLevel&nbsp;=&nbsp;3&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &amp;&amp;&nbsp;CurrentGroup&nbsp;=&nbsp;3,&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;MAX&nbsp;(&nbsp;0,&nbsp;Bonus_campus&nbsp;-&nbsp;4000000&nbsp;),&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;IF&nbsp;(&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;new_std_pd_new_enrol_pct&nbsp;&lt;&nbsp;0.8&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &amp;&amp;&nbsp;BonusLevel&nbsp;=&nbsp;3&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &amp;&amp;&nbsp;CurrentGroup&nbsp;=&nbsp;4,&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;MAX&nbsp;(&nbsp;0,&nbsp;Bonus_campus&nbsp;-&nbsp;3000000&nbsp;),&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;IF&nbsp;(&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;new_std_pd_new_enrol_pct&nbsp;&lt;&nbsp;0.8&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &amp;&amp;&nbsp;BonusLevel&nbsp;=&nbsp;3&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &amp;&amp;&nbsp;CurrentGroup&nbsp;=&nbsp;5,&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;MAX&nbsp;(&nbsp;0,&nbsp;Bonus_campus&nbsp;-&nbsp;3000000&nbsp;),&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;IF&nbsp;(&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;new_std_pd_new_enrol_pct&nbsp;&lt;&nbsp;0.8&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &amp;&amp;&nbsp;BonusLevel&nbsp;=&nbsp;3&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &amp;&amp;&nbsp;CurrentGroup&nbsp;=&nbsp;6,&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;MAX&nbsp;(&nbsp;0,&nbsp;Bonus_campus&nbsp;-&nbsp;3000000&nbsp;),&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;IF&nbsp;(&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;new_std_pd_new_enrol_pct&nbsp;&lt;&nbsp;0.8&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &amp;&amp;&nbsp;BonusLevel&nbsp;=&nbsp;3&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &amp;&amp;&nbsp;CurrentGroup&nbsp;=&nbsp;7,&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;MAX&nbsp;(&nbsp;0,&nbsp;Bonus_campus&nbsp;-&nbsp;1000000&nbsp;),&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;IF&nbsp;(&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;new_std_pd_new_enrol_pct&nbsp;&lt;&nbsp;0.8&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &amp;&amp;&nbsp;BonusLevel&nbsp;=&nbsp;1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &amp;&amp;&nbsp;CurrentGroup&nbsp;&lt;&gt;&nbsp;6&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &amp;&amp;&nbsp;CurrentGroup&nbsp;&lt;&gt;&nbsp;7,&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;0,&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;IF&nbsp;(&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;CurrentGroup&nbsp;=&nbsp;6&nbsp;||&nbsp;CurrentGroup&nbsp;=&nbsp;7,&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;MAX&nbsp;(&nbsp;0,&nbsp;Bonus_campus&nbsp;-&nbsp;500000&nbsp;),&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;MAX&nbsp;(&nbsp;0,&nbsp;Bonus_campus&nbsp;-&nbsp;2000000&nbsp;)&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; )&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; )&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; )&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; )&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; )&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; )&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; )&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; )&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; )&nbsp; &nbsp; &nbsp; &nbsp; )&nbsp;I make a power BI file in this link :&nbsp;https://drive.google.com/file/d/18DuaNV8Fh63Y2Svxy-6-z9pToqCtyMf8/view?usp=share_link&nbsp;Can everyone help me to improve this measure when the values of level of table 2 was changed which this measure do not change ?Note :&nbsp;all of type condition are calculating for March because in April bonus will be change the value. Can the measure apply the conditions for month ?

lbendlin · Answer

What is your concern?&nbsp; You could use SWITCH(TRUE() for the set of nested IFs but that is only syntax sugar, the query plan will be the same.
&nbsp;
I assume you have a good reason to use LOOKUPVALUE.
&nbsp;
Is it slow, or is it not elegant enough?

utatakakawasaki · Answer

Hi&nbsp;lbendlin&nbsp;,&nbsp;How can I apply a measure with a datekey in LOOKUPVALUE ?&nbsp;

lbendlin · Answer

here's a "simplified"&nbsp; version of your measure.
&nbsp;
Bonus Campus = 
VAR NewstdPD = SUM ( 'Campus'[# of New Student PD] )
VAR TargetNewStdPD = SUM ( 'Campus'[# of New Enrol PD Target] )
VAR pct_stdvstarget = DIVIDE ( NewstdPD, TargetNewStdPD )
VAR new_std_pd_reopen_pct = SELECTEDVALUE ( 'Campus'[% New Std PD And Re Open vs Target] )
VAR new_std_pd_new_enrol_pct = SELECTEDVALUE ( 'Campus'[% New Student PD vs New Enrol PD Target] )
VAR CampusCode = SELECTEDVALUE ( Campus[Campus Code] )
VAR CurrentGroup = SELECTEDVALUE ( Bonus[Group] )
VAR K = SELECTEDVALUE ( 'Bonus'[Date] )
VAR datekey = CALCULATE ( MIN ( 'Date'[Date Key] ), 'Date'[Date Key] = VALUE ( K ) )
VAR BonusLevel =
    SWITCH (TRUE (),
        new_std_pd_reopen_pct &gt;= 1.1, 3,
        new_std_pd_reopen_pct &gt;= 1.0, 2,
        new_std_pd_reopen_pct &gt;= 0.9, 1
    )
VAR Bonus_campus = 
    LOOKUPVALUE (
        'Bonus'[Bonus ],
        'Bonus'[Campus], CampusCode,
        'Bonus'[Level ], BonusLevel,
        'Bonus'[Group], CurrentGroup
    )
RETURN
    SWITCH (TRUE (),
    new_std_pd_new_enrol_pct &lt; 0.7, BLANK(),
    new_std_pd_new_enrol_pct &gt;= 0.8, Bonus_campus,
    BonusLevel = 3 &amp;&amp; CurrentGroup in { 1,2 }, MAX ( 0, Bonus_campus - 6000000 ),
    BonusLevel = 3 &amp;&amp; CurrentGroup = 3, MAX ( 0, Bonus_campus - 4000000 ),
    BonusLevel = 3 &amp;&amp; CurrentGroup in { 4,5,6 }, MAX ( 0, Bonus_campus - 3000000 ),
    BonusLevel = 3 &amp;&amp; CurrentGroup = 7, MAX ( 0, Bonus_campus - 1000000 ),
    BonusLevel = 1 &amp;&amp; not CurrentGroup in { 6,7 }, 0,
    CurrentGroup in { 6,7 } ,MAX ( 0, Bonus_campus - 500000 ),
    MAX ( 0, Bonus_campus - 2000000 )
    )
&nbsp;
&nbsp;I think your LOOKUPVALUE can be replaced with a CALCULATE&nbsp; but I don't fully understand the logic behind your data.

utatakakawasaki · Answer

Hi&nbsp;lbendlin&nbsp;,I don't understand how to replace Lookupvalue with Calculate . Can you help me ? ( I attached a power BI file in above )&nbsp;

bhelou · Answer

Dear ,&nbsp;i updated a bit in the PBIX file :&nbsp;1- i created a table for bonus levels&nbsp;2- Updated the measure&nbsp;https://www.dropbox.com/s/m8lx0d2hrnqfp9q/Bonus%20Campus.pbix?dl=0&nbsp;/// in the measure&nbsp;Bonus Campus_Test : replace the value if condition is true and false with the appropriate values for your case&nbsp;Kindly check the updated PBIX file and let me know the approach is correct or no .&nbsp;Kindly accept as a solution and a kudo is appreciated .&nbsp;Thanks .&nbsp;

Forum Discussion

Need help for improving my dax

7 Replies

Related content

Need Performance Improvement Suggestions

Improve performances for Nested.Join

Recommendations to Improve Power BI Incremental Refresh Performance

Improve my dax mesure

Recommendations to Improve Power BI Incremental Refresh Performance