Getting Total Percentage in Card of Column with Percentages in Matrix Table

[julesdude]

Hi all,

I have a table viz in my report with a card above it.

I need the card 'Occupancy Total' to provide a percentage of the listed percentages - a kind of grand total percentage if you like.

The only condition is that it should not include any blank items.

To get the Occupancy column, I use this DAX:

Occupancy = 
DIVIDE([Total Leased Area (Current)], [Total Leasable Area (Current)], 0)

Is it possible to create a new measure, count the non blank rows in the Occupancy column, and calculate the percentage of the percentages? 

[Anonymous · Accepted solution]

Hi @julesdude 

You can use the sumx() function first, then use divide() function

You can refer to the following example

Sample data 

RelatedMeasure

TotalValue = SUM('Table'[value])

Totalcount = COUNTROWS('Table')

Occupancy = DIVIDE([TotalValue],[Totalcount],0)

Displayed visual

Then create a measure to calculate percentage of occupancy

Occupany total = var _sum=SUMX(ALLSELECTED('Table'[Column1]),[Occupancy])
var _count=COUNTROWS(FILTER(ALLSELECTED('Table'[Column1]),[Occupancy]<>BLANK()))
return DIVIDE(_sum,_count)

Output

Best Regards!

Yolo Zhu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.