Hi @bratiranjan ,
It sounds like you're encountering a common data context issue in Power BI. The reason your table visual is showing a single aggregated row for multiple selected campaigns is likely because the visual itself doesn't include the Campaign_ID in its fields. Without it, the DAX measures correctly calculate the totals for everything you've selected in the slicer but have no instruction to break down those results per campaign. To fix this, simply select your table visual and drag the Campaign_ID field into the Columns bucket in the Visualizations pane. This tells Power BI to create a separate row for each unique campaign.
Your Key Performance Indicator (KPI) measures should be standard aggregations. When placed in a table that has the Campaign_ID context, they will automatically calculate correctly for each individual row. Your measures should look something like this:
Total Clicks = SUM('YourFactTable'[Clicks])
Total Orders = SUM('YourFactTable'[Orders])
Total Revenue = SUM('YourFactTable'[Revenue])
Click Through Rate = DIVIDE([Total Clicks], SUM('YourFactTable'[Impressions]))
Conversion Rate = DIVIDE([Total Orders], [Total Clicks])
To achieve your second objective—displaying a single row of "XXX" placeholders when no campaign is selected—the most effective method is to create a new summary table with conditional logic using DAX. This table will form the basis of your visual. In the Modeling tab, select New Table and use the following DAX expression. Remember to replace the table and column names with those from your own model.
Campaign Summary Table =
IF(
NOT(ISFILTERED('Campaigns'[Campaign_ID])),
// If NO campaign is selected, create and return a table with one "XXX" row.
DATATABLE(
"Campaign_ID", STRING,
"Total Clicks", STRING,
"Click Through Rate", STRING,
"Total Orders", STRING,
"Conversion Rate", STRING,
"Total Revenue", STRING,
{
{ "XXX", "XXX", "XXX", "XXX", "XXX", "XXX" }
}
),
// If ANY campaign IS selected, return a summarized table with actual data.
SUMMARIZECOLUMNS(
'Campaigns'[Campaign_ID],
"Total Clicks", FORMAT([Total Clicks], "0"),
"Click Through Rate", FORMAT([Click Through Rate], "0.00%"),
"Total Orders", FORMAT([Total Orders], "0"),
"Conversion Rate", FORMAT([Conversion Rate], "0.00%"),
"Total Revenue", FORMAT([Total Revenue], "$#,##0")
)
)
After creating this Campaign Summary Table, use its columns to build your table visual. The ISFILTERED function checks if a selection has been made on the slicer. If not, it generates the placeholder row using DATATABLE. If a selection is made, it creates a properly summarized table of your campaign data. Note the use of the FORMAT function, which converts all the calculated KPI values to text, ensuring the data type is consistent with the "XXX" string placeholders. Your original slicer will still work perfectly as the DAX expression references the column it filters.
Best regards,
