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
Hi again,
I realized a PBI file might be easier to work with ;)
Here's a link: WeTransfer - PBI Sample File
Community Supporthi, 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/38490
And 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
Hi v-lili6-msft ,
Amazing, it works exactly as intended. Sorry about the sloppy information provided initially :)
I've actually tried with almost the same measure as you provided, the only difference is I didn't include the "_value" and [Measure] in the summarize, but instead had the [Measure] as the expression in the SUMX. Futhermore, it was all done in one measure, not two separate ones. And having played around with your solution it seems like the main trick is having the base measure as a separate measure, and not just a variable, and then another measure to wrap it all up in a SUMX(SUMMARIZE(..)..).
Could you explain why the new measure works? What is the logic behind adding the "_value" in the summarize and then referring to it again in the SUMX? And why does it help to have to separate measures and not one big one with multiple variables?
Whatever the case, thanks a lot! :)
jabrilloHelper I
Hi, can you provide the formula you created? Thanks...