Forum Discussion
Rapports
Helper I
Helper ISUM with filter
Hello, Please I have a problem to do the sum of seance planified by filiere can you please help me to create a mesure for that ?
Hi Rapports ,
Create measure.
If you want to calculate the full sum based on filtering, you can use the following function:
Measure = SUMX( ALLSELECTED('Table'),'Table'[SeancePlanified])If you want to calculate the sum of the groupings based on filtering, you can use the following function:
Measure2 = SUMX( FILTER( ALLSELECTED('Table'),'Table'[filiere]=MAX('Table'[filiere])),'Table'[SeancePlanified])Best Regards,
Liu Yang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly
Hi Rapports ,
Create measure.
If you want to calculate the full sum based on filtering, you can use the following function:
Measure =
SUMX(
ALLSELECTED('Table'),'Table'[SeancePlanified])
If you want to calculate the sum of the groupings based on filtering, you can use the following function:
Measure2 =
SUMX(
FILTER( ALLSELECTED('Table'),'Table'[filiere]=MAX('Table'[filiere])),'Table'[SeancePlanified])
Best Regards,
Liu Yang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly