Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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 🤦
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
37 | |
25 | |
19 | |
14 | |
8 |
User | Count |
---|---|
68 | |
48 | |
45 | |
18 | |
15 |