I'm attempting to use the calulate function to sum a result and apply filters. However the calcultate function only seems to allow me to use a column as a reference but my reference is a measure. Is there a workaround for this in the Calculate function or is there another Dax function that will allow me to sum my measure and apply filters?
Hi,
Just put the measure in place of sum(percentcol), so it should be CALCULATE(COALESCE(percentcol,0)......). The measure be calculated accordingly.
Proud to be a Super User! |  |
Hi,
Just put the measure in place of sum(percentcol), so it should be CALCULATE(COALESCE(percentcol,0)......). The measure be calculated accordingly.
Proud to be a Super User! | |
Helpful resources
FabCon Global Hackathon
Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes!
Power BI Monthly Update - October 2025
Check out the October 2025 Power BI update to learn about new features.
FabCon Atlanta 2026
Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
