How To Display Percentage of Total

Hi Anonymous 

If Settlement is an explicit measure you can use a DAX expression like this:

% Settlement = 
VAR SettlementVal = [Settlement]
VAR AllSettlement =
CALCULATE (
    [Settlement],
    ALL ( Table1[Channel] )
)
VAR Result = DIVIDE ( SettlementVal, AllSettlement )
RETURN Result

If you've simply dropped the Settlement column from your data model and allowed Power BI to aggregate the result (i.e. an implicit measure), then simply add the column to the table again, right click it in the 'Values' field well and select Show value as>>Percent of grant total.

Best regards,

Martyn

If I answered your question, please help others by accepting it as a solution.