Forum Discussion
Total not showing (DAX Measure)
hi, LAMLAM
Sample data and expected output would help tremendously.
Please see this post regarding How to Get Your Question Answered Quickly:
https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490And for your case, just add a measure like this:
Measure 3 = var _table=SUMMARIZE(DimProject,DimProject[ProjectName],DimProject[StartDate],DimProject[EndDate],"_value",[Measure]) return SUMX(_table,[_value])
Result:
Best Regards,
Lin
Try wrapping your function with SUMX:
SUMX (
VALUES( T [C] ), //whatever is on rows to sum up
CALCULATE(
SUM('Finance DW_FactFinance'[Value]);
'Shared DW_DimVersion'[VersionName]="Actual";
DATESBETWEEN(DimDate[Date];DATE(1900;1;1);MAX(DimDate[Date]));
FILTER(DimProject;
MAX(DimDate[Date])>=MAX(DimProject[StartDate]) &&
OR(
MAX(DimDate[Date])<=MAX(DimProject[ActualEndingDate]);
MAX(DimProject[ActualEndingDate])=BLANK())))
)Hi Anonymous ,
No luck, unfortunately.
I don't know if it helps to say that my data model looks like this. Basically, I wanna be able to filter on a specific organization, which then only returns a given set of projects, which then again filters my fact. At the same time I want to only have open projects, hence my last 5 lines in the measure.
any chance you can load some sample data?
Hi Anonymous ,
Try this link with excel sample data: WeTransfer
So once again. What I am trying to achieve is to get the sum of my values, but only for projects that are open in the period selected in the dimdate dimension.
Best regards
