Forum Discussion
Total not showing (DAX Measure)
Hi,
I'm having trouble with a measure not showing any total in tables and other visuals. The idea with the measure is to have a running total for projects that are open given the selected period (month). I'm pretty sure that it is the date filtering happening on the project dimension in the measure that interferes with the total.
On the row-level the measure works just fine...
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
8 Replies
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.
