Skip to main content

Search

Report Dashboard KPI Calculation Logic

reportkpi.jpg

Planned

Shows the total number of planned communication records displayed in the Report dashboard.

DAX Formula

Report Planned =
COUNT('Distribution Status'[ID_Distribution])

Calculation Logic

The measure counts all records in the Distribution Status table by ID_Distribution. It represents the total number of planned communications for the selected reporting period and active filters.

Sent

Shows the number of communications that entered the sending process.

DAX Formula

Report 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"
        }
    )
)

Calculation Logic

The measure counts communication records with statuses showing that the message entered the sending process. It includes successfully processed communications as well as records with unsuccessful sending or delivery statuses.

Sent %

Shows the percentage of planned communications that were sent.

DAX Formula

Report Sent % =
[Report Sent] / [Report Planned]

Calculation Logic

The measure divides the number of sent communications by the total number of planned communications. It helps users evaluate how many planned messages were processed for sending.

Delivered

Shows the number of communications successfully delivered to recipients.

DAX Formula

Report Delivered =
CALCULATE(
    COUNT('Distribution Status'[ID_Distribution]), 
    FILTER(
        'Distribution Status',
        'Distribution Status'[Distribution_Sending_Status] IN {
            "DELIVERED", "READ", "VISITED", "SEEN"
        }
    )
)

Calculation Logic

The measure counts communication records 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 communications that were delivered.

DAX Formula

Report Delivere % =
[Report Delivered] / [Report Sent]

Calculation Logic

The measure divides the number of delivered communications by the number of sent communications.

Read

Shows the number of communications read or seen by recipients.

DAX Formula

Report Read =
CALCULATE(
    COUNT('Distribution Status'[ID_Distribution]), 
    FILTER(
        'Distribution Status',
        'Distribution Status'[Distribution_Sending_Status] IN {
            "READ", "VISITED", "SEEN"
        }
    )
)

Calculation Logic

The measure counts communication records with statuses that indicate recipient reading or viewing activity. Communications with the VISITED status are also included because link visits happen after recipient engagement.

Read %

Shows the percentage of delivered communications that were read by recipients.

DAX Formula

Report Read % =
[Report Read] / [Report Delivered]

Calculation Logic

The measure divides the number of read communications by the number of delivered communications. It helps users evaluate recipient engagement after delivery.

Visited

Shows the number of communications where recipients visited a link.

DAX Formula

Report Visited =
CALCULATE(
    COUNT('Distribution Status'[ID_Distribution]), 
    FILTER(
        'Distribution Status',
        'Distribution Status'[Distribution_Sending_Status] IN {
            "VISITED"
        }
    )
)

Calculation Logic

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

Visited %

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

DAX Formula

Report Visited % =
[Report Visited] / [Report Read]

Calculation Logic

The measure divides the number of visited communications by the number of read communications. It helps users evaluate how effectively read messages drive further recipient interaction.

Undelivered

Shows the number of sent communications that were not delivered.

DAX Formula

Report 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"
        }
    )
)

Calculation Logic

The measure counts communication records with statuses that indicate delivery failure. It helps users identify the volume of communications that entered the sending process but were not delivered to recipients.

Undelivered %

Shows the percentage of sent communications that were not delivered.

DAX Formula

Report Undelivered % =
[Report Undelivered] / [Report Sent]

Calculation Logic

The measure divides the number of undelivered communications by the number of sent communications. It helps users evaluate the share of delivery failures among all sent records.

Unsent

Shows the number of planned communications that were not sent.

DAX Formula

Report 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"
        }
    )
)

Calculation Logic

The measure counts planned communication records that were not sent because of duplicate records, invalid or missing recipient data, content issues, message limits, exclusions, unsubscribed recipients, failed processing, declined status, or unverified records.

Unsent %

Shows the percentage of planned communications that were not sent.

DAX Formula

Report Unsent % =
[Report Unsent] / [Report Planned]

Calculation Logic

The measure divides the number of unsent communications by the number of planned communications. It helps users understand what share of planned communication activity did not enter the sending process.