Forum Discussion
How to write DAX statement using where condition
Here is the visual of power BI report shown below for summary table. The Actual, budget values are summing up for Sales, Cost of Sales, Gross Profit in % of Sales. But I am looking for an average ...
Looks like your column in Level 2 has 3 values, and you are using just 1 measure.
You cannot change the measure properties of 1 of the row values. (To show 2 rows as sum and one row as percentage)
Have you tried "Percentage of Grandtotal" ?
Anonymous, Yes when I try using show value as percentage of grand total, the other parameters (Sales, Cost of Sales) are changing as well.
Looks like your column in Level 2 has 3 values, and you are using just 1 measure.
You cannot change the measure properties of 1 of the row values. (To show 2 rows as sum and one row as percentage)