cancel
Showing results for
Did you mean:
Highlighted
vmontaldo Frequent Visitor

## Calculate total sum and total count of a calculate column in a grid with a date selected

Hi,

I need Help for these calculation: The column to calcolate is:

Meet 50% = IF([SUM_RESULT]>5;1;0)

where :

SUM_RESULT = calculate(sum(TABLE[RESULT_CONDIZIONE]);DATESBETWEEN(TABLE_CALENDAR[Day].[Date];TABLE[12_previous_month];TABLE[select_month]))

select_month = SELECTEDVALUE('TABLE_CALENDAR'[Day])

I would calculate the total of calculated column Meet 50% (box TOTAL 50%) in this exemple = 5

I would calculate the total count value of calculated column Meet 50% (box COUNT 50%) in this exemple = 14

I tried without success:

TOTAL 50% = SUMX(TABLE;IF([SUM_RESULT]>5;1;0))

COUNT 50% = COUNTX(TABLE;IF([SUM_RESULT]>5;1;0))

Regards Valentina

1 ACCEPTED SOLUTION

Accepted Solutions
vmontaldo Frequent Visitor

## Re: Calculate total sum and total count of a calculate column in a grid with a date selected

hi,

I risolved :

TOTAL 50%=

SUMX (
SUMMARIZE( TABLE;

TABLE[n_PLA];

TABLE[KPI_DESCRIPTION];

"Meet 50%";IF([SUM_RESULT]>5;1;0)

)
;  [Meet 50%]

)

COUNT 50%  =

COUNTX (
SUMMARIZE( TABLE;

TABLE[n_PLA];

TABLE[KPI_DESCRIPTION];

"Meet 50%";IF([SUM_RESULT]>5;1;0)

)
;  [Meet 50%]

)

Regards thanks Valentina

vmontaldo Frequent Visitor

## Re: Calculate total sum and total count of a calculate column in a grid with a date selected

hi,

I risolved :

TOTAL 50%=

SUMX (
SUMMARIZE( TABLE;

TABLE[n_PLA];

TABLE[KPI_DESCRIPTION];

"Meet 50%";IF([SUM_RESULT]>5;1;0)

)
;  [Meet 50%]

)

COUNT 50%  =

COUNTX (
SUMMARIZE( TABLE;

TABLE[n_PLA];

TABLE[KPI_DESCRIPTION];

"Meet 50%";IF([SUM_RESULT]>5;1;0)

)
;  [Meet 50%]

)

Regards thanks Valentina

Announcements #### New Topics Started Badges Coming  