Dax Help

[sameergupta60]

we are using below dax to get the value:-

Planned YTD ASTA =

CALCULATE(SUM('Master list Actuals'[Value (Cr)]),FILTER('Master list Actuals','Milestone Booking Level Details'[Project: Project Name]=EARLIER('Milestone Booking Level Details'[Project: Project Name]) && DATE(YEAR('Milestone Booking Level Details'[Finish]),MONTH('Milestone Booking Level Details'[Finish]),DAY('Milestone Booking Level Details'[Finish]))<>BLANK()))

using the above dax we get the sum of the projects but we don't want the sum of the projects we want row total which display in visual.

[v-zhangti]

Hi, @sameergupta60 

From your formula, we can see that [Planned YTD ASTA] is a calculated column. You can try the following formula.

Measure:

Measure = 
IF (
    ISINSCOPE ( 'Milestone Booking Level Details'[Project: Project Name]),
    SUM ( 'Milestone Booking Level Details'[Planned YTD ASTA] ),
    BLANK ()
)

This formula can make [Planned YTD ASTA] appear blank in row total. Hope that helps you.

Best Regards,

Community Support Team _Charlotte

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[sameergupta60]

Thanks for the solution but it is not solving my purpose.

I will explain again,

Planned YTD ASTA =

CALCULATE(SUM('Master list Actuals'[Value (Cr)]),FILTER('Master list Actuals','Milestone Booking Level Details'[Project: Project Name]=EARLIER('Milestone Booking Level Details'[Project: Project Name]) && DATE(YEAR('Milestone Booking Level Details'[Finish]),MONTH('Milestone Booking Level Details'[Finish]),DAY('Milestone Booking Level Details'[Finish]))<>BLANK()))

i am able to get value.

But in visual when we add the column planned ytd asta using don't summarize option.

why we select the don't summarize option is to get the data value of milestone in the row, if we select option sum it is showing a total,

but we want rows wise total from planned ytd asta Colum Dax.

which is shown in the above screen shot.

thank again in advance for the value solution

[PijushRoy]

Hi @sameergupta60 

Can you please use Additional condition in your DAX like
IF(IsBlank(SelectedValue([Project: Project Name]),SUM(.........),CALCULATE(SUM('Master list Actuals'[Value (Cr)]),FILTER('Master list Actuals','Milestone Booking Level Details'[Project: Project Name]=EARLIER('Milestone Booking Level Details'[Project: Project Name]) && DATE(YEAR('Milestone Booking Level Details'[Finish]),MONTH('Milestone Booking Level Details'[Finish]),DAY('Milestone Booking Level Details'[Finish]))<>BLANK())))

Let me know, it works or not

If solve your requirement, please mark this answer as SOLUTION
If this comment helps you, please LIKE this comment/Kudos