Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
sameergupta60
Helper IV
Helper IV

Dax Help

 

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()))

 

sameergupta60_0-1663396190409.png

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.

3 REPLIES 3
v-zhangti
Community Support
Community Support

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 ()
)

vzhangti_0-1663568036752.png

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.

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
Super User
Super User

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

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.