Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now

Reply
Anonymous
Not applicable

SUMX in dynamic Calculation Group

Hi all,

 

I have the following measure which I would like to place in a calculation group so that I do not need to recreate this for each measure I want to use it. 

The following measure I use to calculate an average/ index 

 

 

_IndexMeasure = 
VAR _Months =
    CALCULATE ( DISTINCTCOUNT ( 'Date'[Month Year Long] ), REMOVEFILTERS () )
VAR _Index =
    CALCULATE (
        SUMX ( 'Table1', 'Table1'[Value %] ),
        REMOVEFILTERS ( 'Date'[Month Year Long] )
    )
RETURN
    DIVIDE ( _Index, _Months )

 

 


Now I want to put this in an calulated column, and I would expect that I need to do the same things as if you want to implement it as a regular measure, so;

 

 

VAR _Months =
    CALCULATE ( DISTINCTCOUNT ( 'Date'[Month Year Long] ), REMOVEFILTERS () )
VAR _Index =
    CALCULATE (
        SUMX ( SELECTEDMEASURE() ),
        REMOVEFILTERS ( 'Date'[Month Year Long] )
    )
RETURN
    DIVIDE ( _Index, _Months )

 

 

But this does not work, because SUMX() needs 2 parameters. But how can I make this dynamic so that I can use the exact same functionality for other columns/ tables as well?

1 ACCEPTED SOLUTION
ppm1
Solution Sage
Solution Sage

Why do you need the SUMX? I would try it with just

 

CALCULATE(SELECTEDMEASURE(), ...

 

Pat

 

Microsoft Employee

View solution in original post

2 REPLIES 2
ppm1
Solution Sage
Solution Sage

Why do you need the SUMX? I would try it with just

 

CALCULATE(SELECTEDMEASURE(), ...

 

Pat

 

Microsoft Employee
Anonymous
Not applicable

Thank you, this works as well. 

Helpful resources

Announcements
OCT PBI Update Carousel

Power BI Monthly Update - October 2024

Check out the October 2024 Power BI update to learn about new features.

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

October NL Carousel

Fabric Community Update - October 2024

Find out what's new and trending in the Fabric Community.