Telegram Dashboard KPI Calculation Logic – Proxima Research International

The Telegram dashboard displays KPI cards, charts, and detailed table metrics for Telegram communication performance.

Planned
Sent
Sent %
Delivered
Delivered %
Read
Read %
Visited
Visited %
Unsubscribed
Unsubscribed %
Undelivered
Undelivered %
Unsent
Unsent %
Telegram Delivered Dynamic
Telegram Read Dynamic
Telegram Undelivered Dynamic
Telegram Visited Dynamic

Planned

Shows the total number of Telegram messages planned for sending during the selected reporting period.

DAX Formula

Telegram Planned =
CALCULATE(
    COUNT('Distribution Status'[ID_Distribution]), 
    'Distribution'[Communication_channel] = "telegram"
)

Calculation Logic

The measure counts all distribution records where the communication channel is telegram. It represents the total number of planned Telegram messages for the selected period and filters.

Sent

Shows the number of Telegram messages that entered the sending process.

DAX Formula

Telegram Sent =
CALCULATE(
    COUNT('Distribution Status'[ID_Distribution]), 
    FILTER(
        'Distribution Status',
        'Distribution Status'[Distribution_Sending_Status] IN {
            "DELIVERED", "BOUNCED", "DECLINED", "DEFERRED", "EXPIRED",
            "FAILED", "OLD", "REJECTED", "UNDELIVERABLE", "UNDELIVERED",
            "UNKNOWN", "ENQUEUED", "QUEUED", "SENT", "VISITED", "READ", "SEEN"
        }
        && RELATED('Distribution'[Communication_channel]) = "telegram"
    )
)

Calculation Logic

The measure counts Telegram messages with statuses that indicate the message entered the sending process. It includes successfully processed messages and messages with unsuccessful delivery statuses.

Sent %

Shows the percentage of planned Telegram messages that were sent.

DAX Formula

Telegram Sent % =
[Telegram Sent] / [Telegram Planned]

Calculation Logic

The measure divides the number of sent Telegram messages by the number of planned Telegram messages.

Delivered

Shows the number of Telegram messages successfully delivered to recipients.

DAX Formula

Telegram Delivered =
CALCULATE(
    COUNT('Distribution Status'[ID_Distribution]), 
    FILTER(
        'Distribution Status',
        'Distribution Status'[Distribution_Sending_Status] IN {
            "DELIVERED", "READ", "VISITED", "SEEN"
        }
        && RELATED('Distribution'[Communication_channel]) = "telegram"
    )
)

Calculation Logic

The measure counts Telegram messages with delivery-related statuses. Statuses such as READ, VISITED, and SEEN are included because these actions can occur only after successful delivery.

Delivered %

Shows the percentage of sent Telegram messages that were successfully delivered.

DAX Formula

Telegram Delivered % =
[Telegram Delivered] / [Telegram Sent]

Calculation Logic

The measure divides the number of delivered Telegram messages by the number of sent Telegram messages.

Read

Shows the number of Telegram messages read or seen by recipients.

DAX Formula

Telegram Read =
CALCULATE(
    COUNT('Distribution Status'[ID_Distribution]), 
    FILTER(
        'Distribution Status',
        'Distribution Status'[Distribution_Sending_Status] IN {
            "READ", "VISITED", "SEEN"
        }
        && RELATED('Distribution'[Communication_channel]) = "telegram"
    )
)

Calculation Logic

The measure counts Telegram messages with statuses that indicate recipient reading or viewing activity. Messages with VISITED status are also included because link visits happen after recipient engagement.

Read %

Shows the percentage of delivered Telegram messages that were read by recipients.

DAX Formula

Telegram Read % =
[Telegram Read] / [Telegram Delivered]

Calculation Logic

The measure divides the number of read Telegram messages by the number of delivered Telegram messages.

Visited

Shows the number of Telegram messages where recipients visited a link.

DAX Formula

Telegram Visited =
CALCULATE(
    COUNT('Distribution Status'[ID_Distribution]), 
    FILTER(
        'Distribution Status',
        'Distribution Status'[Distribution_Sending_Status] IN {
            "VISITED"
        }
        && RELATED('Distribution'[Communication_channel]) = "telegram"
    )
)

Calculation Logic

The measure counts Telegram messages with the VISITED status. It shows how many Telegram communications generated link interaction.

Visited %

Shows the percentage of read Telegram messages that resulted in a link visit.

DAX Formula

Telegram Visited % =
[Telegram Visited] / [Telegram Read]

Calculation Logic

The measure divides the number of Telegram messages with link visits by the number of read Telegram messages.

Unsubscribed

Shows the number of recipients who unsubscribed from Telegram communications.

DAX Formula

Telegram Unsubscribed =
CALCULATE(
    COUNT('Unsubscribed'[ID_Unsubscribed]), 
    'Distribution'[Communication_channel] = "telegram"
)

Calculation Logic

The measure counts unsubscribe records for the telegram communication channel.

Unsubscribed %

Shows the percentage of delivered Telegram messages that resulted in an unsubscribe action.

DAX Formula

Telegram Unsubscribed % =
[Telegram Unsubscribed] / [Telegram Delivered]

Calculation Logic

The measure divides the number of Telegram unsubscribe records by the number of delivered Telegram messages.

Undelivered

Shows the number of sent Telegram messages that were not delivered.

DAX Formula

Telegram Undelivered =
CALCULATE(
    COUNT('Distribution Status'[ID_Distribution]), 
    FILTER(
        'Distribution Status',
        'Distribution Status'[Distribution_Sending_Status] IN {
            "UNDELIVERED", "UNDELIVERABLE",
            "RESENDING_SMS_UNDELIVERED",
            "RESENDING_SMS_UNDELIVERABLE",
            "EXPIRED", "OLD", "BOUNCED",
            "DEFERRED", "UNKNOWN"
        }
        && RELATED('Distribution'[Communication_channel]) = "telegram"
    )
)

Calculation Logic

The measure counts Telegram messages with statuses that indicate delivery failure.

Undelivered %

Shows the percentage of sent Telegram messages that were not delivered.

DAX Formula

Telegram Undelivered % =
[Telegram Undelivered] / [Telegram Sent]

Calculation Logic

The measure divides the number of undelivered Telegram messages by the number of sent Telegram messages.

Unsent

Shows the number of planned Telegram messages that were not sent.

DAX Formula

Telegram Unsent =
CALCULATE(
    COUNT('Distribution Status'[ID_Distribution]), 
    FILTER(
        'Distribution Status',
        'Distribution Status'[Distribution_Sending_Status] IN {
            "DUPLICATE", "INVALID_EMAIL", "EMPTY_RECIPIENT",
            "EMPTY_CONTENT", "MESSAGE_LIMIT", "EXCLUDED",
            "UNSUBSCRIBED", "FAILED", "DECLINED", "UNVERIFIED"
        }
        && RELATED('Distribution'[Communication_channel]) = "telegram"
    )
)

Calculation Logic

The measure counts planned Telegram messages that were not sent because of restrictions, duplicate records, missing recipient data, failed processing, unsubscribe status, or other sending issues.

Unsent %

Shows the percentage of planned Telegram messages that were not sent.

DAX Formula

Telegram Unsent % =
[Telegram Unsent] / [Telegram Planned]

Calculation Logic

The measure divides the number of unsent Telegram messages by the number of planned Telegram messages.

Telegram Delivered Dynamic

Shows the number of delivered Telegram messages over time for the selected dynamic period.

DAX Formula

Telegram Delivered Dynamic =
VAR N = [DaysToShow Telegram]
VAR MaxDate =
    CALCULATE (
        MAX ( 'Distribution Status'[Send_DateOnly] ),
        ALL ( 'Distribution Status' )
    )
VAR Mode = SELECTEDVALUE(PeriodMode[Mode], "Day")
VAR StartDate_Day = MaxDate - (N - 1)
VAR StartDate_Month =
    DATE(
        YEAR ( EOMONTH ( MaxDate, -N + 1 ) ),
        MONTH( EOMONTH ( MaxDate, -N + 1 ) ),
        1
    )
VAR StartDate = IF(Mode = "Month", StartDate_Month, StartDate_Day)
RETURN
CALCULATE (
    COUNT ( 'Distribution Status'[ID_Distribution] ),
    FILTER (
        ALL ( 'Distribution Status'[Send_DateOnly] ),
        'Distribution Status'[Send_DateOnly] >= StartDate
            && 'Distribution Status'[Send_DateOnly] <= MaxDate
    ),
    KEEPFILTERS (
        'Distribution Status'[Distribution_Sending_Status] IN {
            "DELIVERED", "READ", "VISITED", "SEEN"
        }
    ),
    KEEPFILTERS ( 'Distribution'[Communication_channel] = "telegram" ),
    REMOVEFILTERS ( 'Calendar' ),
    REMOVEFILTERS ( 'PeriodsFilter' )
)

Calculation Logic

The measure calculates the number of delivered Telegram messages for the selected dynamic period. It uses DaysToShow Telegram and the selected period mode, such as Day or Month, to define the displayed date range.

Telegram Read Dynamic

Shows the number of read Telegram messages over time for the selected dynamic period.

DAX Formula

Telegram Read Dynamic =
VAR N = [DaysToShow Telegram]
VAR MaxDate =
    CALCULATE (
        MAX ( 'Distribution Status'[Send_DateOnly] ),
        ALL ( 'Distribution Status' )
    )
VAR Mode = SELECTEDVALUE(PeriodMode[Mode], "Day")
VAR StartDate_Day = MaxDate - (N - 1)
VAR StartDate_Month =
    DATE(
        YEAR ( EOMONTH ( MaxDate, -N + 1 ) ),
        MONTH( EOMONTH ( MaxDate, -N + 1 ) ),
        1
    )
VAR StartDate = IF(Mode = "Month", StartDate_Month, StartDate_Day)
RETURN
CALCULATE (
    COUNT ( 'Distribution Status'[ID_Distribution] ),
    FILTER (
        ALL ( 'Distribution Status'[Send_DateOnly] ),
        'Distribution Status'[Send_DateOnly] >= StartDate
            && 'Distribution Status'[Send_DateOnly] <= MaxDate
    ),
    KEEPFILTERS (
        'Distribution Status'[Distribution_Sending_Status] IN {
            "READ", "VISITED", "SEEN"
        }
    ),
    KEEPFILTERS ( 'Distribution'[Communication_channel] = "telegram" ),
    REMOVEFILTERS ( 'Calendar' ),
    REMOVEFILTERS ( 'PeriodsFilter' )
)

Calculation Logic

The measure calculates the number of Telegram messages read by recipients within the selected dynamic period. It is used in the Message Delivery & Engagement Trends chart.

Telegram Undelivred Dynamic

Shows the number of undelivered Telegram messages over time for the selected dynamic period.

DAX Formula

Telegram Undelivred Dynamic =
VAR N = [DaysToShow Telegram]
VAR MaxDate =
    CALCULATE (
        MAX ( 'Distribution Status'[Send_DateOnly] ),
        ALL ( 'Distribution Status' )
    )
VAR Mode = SELECTEDVALUE(PeriodMode[Mode], "Day")
VAR StartDate =
    SWITCH (
        TRUE(),
        Mode = "Day", MaxDate - (N - 1),
        Mode = "Month", EOMONTH(MaxDate, -N + 1) + 1,
        MaxDate - N
    )
RETURN
CALCULATE (
    COUNT ( 'Distribution Status'[ID_Distribution] ),
    FILTER (
        ALL ( 'Distribution Status'[Send_DateOnly] ),
        'Distribution Status'[Send_DateOnly] >= StartDate
            && 'Distribution Status'[Send_DateOnly] <= MaxDate
    ),
    KEEPFILTERS (
        'Distribution Status'[Distribution_Sending_Status] IN {
            "UNDELIVERED", "UNDELIVERABLE",
            "RESENDING_SMS_UNDELIVERED",
            "RESENDING_SMS_UNDELIVERABLE",
            "EXPIRED", "OLD", "BOUNCED",
            "DEFERRED", "UNKNOWN"
        }
    ),
    KEEPFILTERS ( 'Distribution'[Communication_channel] = "telegram" ),
    REMOVEFILTERS ( 'Calendar' ),
    REMOVEFILTERS ( 'PeriodsFilter' )
)

Calculation Logic

The measure calculates the number of undelivered Telegram messages within the selected dynamic period. It is used to show delivery failure dynamics over time.

Telegram Visited Dynamic

Shows the number of Telegram messages with link visits over time for the selected dynamic period.

DAX Formula

Telegram Visited Dynamic =
VAR N = [DaysToShow Telegram]
VAR MaxDate =
    CALCULATE (
        MAX ( 'Distribution Status'[Send_DateOnly] ),
        ALL ( 'Distribution Status' )
    )
VAR Mode = SELECTEDVALUE(PeriodMode[Mode], "Day")
VAR StartDate =
    SWITCH (
        TRUE(),
        Mode = "Day", MaxDate - (N - 1),
        Mode = "Month", EOMONTH(MaxDate, -N + 1) + 1,
        MaxDate - N
    )
RETURN
CALCULATE (
    COUNT ( 'Distribution Status'[ID_Distribution] ),
    FILTER (
        ALL ( 'Distribution Status'[Send_DateOnly] ),
        'Distribution Status'[Send_DateOnly] >= StartDate
            && 'Distribution Status'[Send_DateOnly] <= MaxDate
    ),
    KEEPFILTERS (
        'Distribution Status'[Distribution_Sending_Status] IN {
            "VISITED"
        }
    ),
    KEEPFILTERS ( 'Distribution'[Communication_channel] = "telegram" ),
    REMOVEFILTERS ( 'Calendar' ),
    REMOVEFILTERS ( 'PeriodsFilter' )
)

Calculation Logic

The measure calculates the number of Telegram messages where recipients visited a link during the selected dynamic period. It is used in the trend chart to show Telegram link visit activity over time.

Search

Planned

Sent

Sent %

Delivered

Delivered %

Read

Read %

Visited

Visited %

Unsubscribed

Unsubscribed %

Undelivered

Undelivered %

Unsent

Unsent %

Telegram Delivered Dynamic

Telegram Read Dynamic

Telegram Undelivred Dynamic

Telegram Visited Dynamic