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
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 )
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?
Solved! Go to Solution.
Why do you need the SUMX? I would try it with just
CALCULATE(SELECTEDMEASURE(), ...
Pat
Why do you need the SUMX? I would try it with just
CALCULATE(SELECTEDMEASURE(), ...
Pat
Thank you, this works as well.
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
110 | |
99 | |
95 | |
88 | |
70 |
User | Count |
---|---|
165 | |
131 | |
129 | |
102 | |
98 |