Dear Community,
i want to display the quarter in card the rows number is the right number but i dont know what is this number or from where is coming
this is the measure i used
the quarter = SUMX(ALLEXCEPT(Append1,Append1[quarter no 1]),[IDP Arrived IND 2018+2019])
thank you in advance
1 ACCEPTED SOLUTION
Hi @NourJ ,
To create a measure as below.
the quarter = var q = MAX(Append1[quarter no 1]) return CALCULATE(SUM(Append1[IDP Arrived IND 2018+2019]),FILTER(ALL(Append1),Append1[quarter no 1]=q))
Hi @NourJ ,
To create a measure as below.
the quarter = var q = MAX(Append1[quarter no 1]) return CALCULATE(SUM(Append1[IDP Arrived IND 2018+2019]),FILTER(ALL(Append1),Append1[quarter no 1]=q))
Helpful resources
Join our Fabric User Panel
Share feedback directly with Fabric product managers, participate in targeted research studies and influence the Fabric roadmap.
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.
| User | Count |
|---|---|
| 62 | |
| 62 | |
| 42 | |
| 21 | |
| 18 |
