Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
If I create a Summarize as below how can I refrence in another measure? I also tried with Group By and still get the same error. It works as variable, but not stand alone measure.
Grps =
var _Max_Date = MAX('Calendar Service'[Date])
var _Min_Date = MIN('Calendar Service'[Date])
VAR _PHASE = ALLSELECTED('DIM'[PHASE])
RETURN
SUMMARIZE(FILTER(Group_Details,([DATE] >= _Min_Date && [DATE]<= _Max_Date),'001 Table'[Grp_NB])
Use it in below measure:
Measure 2-A=
CALCULATE(SUMX(VALUES('Table'[ID]),1), KEEPFILTERS(NOT 'Table'[GrpNum] IN [Grps] ))
or
Measure 2-B=
SUMMARIZE(
FILTER( 'Table' , NOT [Grps] IN [Grps] && ALLSELECTED('Table'[_ID]) IN [ID_12]
&& ('Table'[Date] >= _Max_12_MOS && 'Table'[Date] <= _Max_Date)),'Table'[GrpNum])
I get an error: [Grps] is not a valid Table.
Hi @NilR ,
Does that make sense? If so, kindly mark @amitchandak 's answer as the solution to close the case please. Thanks in advance.
Best Regards
Community Support Team _ Polly
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
unfortuntly, this is what I had and trying to create something similar to dynamic table with either group by or Summarize
@NilR , keep summarize code in measure else it will be static
Grps =
var _Max_Date = MAX('Calendar Service'[Date])
var _Min_Date = MIN('Calendar Service'[Date])
VAR _PHASE = ALLSELECTED('DIM'[PHASE])
var _tab = SUMMARIZE(FILTER(Group_Details,([DATE] >= _Min_Date && [DATE]<= _Max_Date),'001 Table'[Grp_NB])
RETURN
CALCULATE(SUMX(VALUES('Table'[ID]),1), filter('Table', NOT 'Table'[GrpNum] IN [Grps] ))
or
Grps =
var _Max_Date = MAX('Calendar Service'[Date])
var _Min_Date = MIN('Calendar Service'[Date])
VAR _PHASE = ALLSELECTED('DIM'[PHASE])
var _tab = SUMMARIZE(FILTER(Group_Details,([DATE] >= _Min_Date && [DATE]<= _Max_Date),'001 Table'[Grp_NB])
RETURN
CALCULATE(SUMX(VALUES('Table'[ID]),1), filter(all('Table'[GrpNum]), NOT 'Table'[GrpNum] IN [Grps] ))
@amitchandak Thank you! I have about 6 measures using the Summaries and I was hoping to pull this out to increase the performance. It takes decades to load 🤦
User | Count |
---|---|
47 | |
26 | |
21 | |
17 | |
15 |
User | Count |
---|---|
53 | |
34 | |
17 | |
17 | |
15 |