Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
we are using below dax to get the value:-
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.
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.
Thanks for the solution but it is not solving my purpose.
I will explain again,
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
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
65 |
User | Count |
---|---|
136 | |
118 | |
101 | |
71 | |
61 |