User Profile
GanesaMoorthyGM
Helper II
Joined 1 year ago
User Widgets
Contributions
Request to Add additional Column in Power BI Matrix Visual
New Power BI Requirement Currently, in the Matrix visual: Countries are displayed as columns. Measures are displayed as rows using the "Show values on rows" option. Each measure (e.g., Sales, Ticket Size, Growth %, etc.) appears vertically, while countries appear horizontally across the top. Enhancement Required I would like to add an additional column named "EOA Total" in the Matrix visual. Expected Behavior Current Layout: Measure India UAE Singapore Malaysia Sales ... ... ... ... Ticket Size ... ... ... ... Growth % ... ... ... ... Required Layout: Measure India UAE Singapore Malaysia EOA Total Sales ... ... ... ... Total Ticket Size ... ... ... ... Total Growth % ... ... ... ... Total The EOA Total column should display the aggregated value across all EOA countries for each measure while retaining the existing country-wise columns. EOA is nothing but the Countries excluding US. so if we write as a measure we cant use measure field as column. So what can we do here. My sample measure: MTD Target (INR Lakhs) = VAR MaxSalesDate = CALCULATE( MAX ( 'fact_sales'[DateOnly] ), ALL ( 'fact_sales' ) ) VAR CurrentMonthNumber = MONTH ( MaxSalesDate ) VAR FiscalMonth = SWITCH ( TRUE (), CurrentMonthNumber = 4, 1, CurrentMonthNumber = 5, 2, CurrentMonthNumber = 6, 3, CurrentMonthNumber = 7, 4, CurrentMonthNumber = 8, 5, CurrentMonthNumber = 9, 6, CurrentMonthNumber = 10, 7, CurrentMonthNumber = 11, 8, CurrentMonthNumber = 12, 9, CurrentMonthNumber = 1, 10, CurrentMonthNumber = 2, 11, CurrentMonthNumber = 3, 12 ) VAR CurrentFYCode = IF ( CurrentMonthNumber >= 4, "FY" & RIGHT ( YEAR ( MaxSalesDate ) + 1, 2 ), "FY" & RIGHT ( YEAR ( MaxSalesDate ), 2 ) ) -- ✅ Check if target exists VAR TargetAvailable = CALCULATE ( COUNTROWS ( 'Clusterwise Overall Target' ), 'Clusterwise Overall Target'[FY] = CurrentFYCode, 'Clusterwise Overall Target'[MonthOrder] = FiscalMonth ) VAR RawTotal = IF ( TargetAvailable > 0, CALCULATE ( SUMX ( FILTER ( 'Clusterwise Overall Target', 'Clusterwise Overall Target'[FY] = CurrentFYCode && 'Clusterwise Overall Target'[MonthOrder] = FiscalMonth && 'Clusterwise Overall Target'[Country] IN { "UAE", "Oman", "Singapore", "Qatar","Kuwait", "Ecom", "US", "US E.comm" } ), VAR Country = 'Clusterwise Overall Target'[Country] VAR ConversionRate = SWITCH ( TRUE (), -- FY26 CurrentFYCode = "FY26" && Country IN { "US", "US E.comm" }, 86, CurrentFYCode = "FY26", 23, -- FY27 CurrentFYCode = "FY27" && Country IN { "US", "US E.comm" }, 90, -- FY27 non US CurrentFYCode = "FY27", 10 ) RETURN -- ✅ ✅ ONLY CHANGE: Cr → Lakhs ( 'Clusterwise Overall Target'[Target] * ConversionRate ) * 10 ) ) ) RETURN ROUND ( COALESCE ( RawTotal, 0 ), 1) Kindly help me fix this requirement.Share % Measure Logic tweak help
Hi guys, So i was in a new requirement of converting excel report into power bi and i somehow fixed the template and finished. excel template: Now i need your help in writing one particular measure so this is how my matrix look like so now my share contribution logic is See we have btq age band 0-30 days etc.. and with MC band at top like <10% etc.. so for example here mc band <10% the btq age bad 0-30 days sale is 0.09 and the total sale in btq age band is 2.16 so 0.09/2.16 = 4% this is the logic. so i need your help in fixing this. this is my sale measure name All Country MTD Sales MC Band Exclusion thank you.
