Forum Discussion
Solved
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 (mo...
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
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