GET GRAND TOTAL OF COLUMNS ACROSS ALL COLUMNS VALUES

[Anonymous]

Hello, I managed to get the following measure

ZZZ =

CALCULATE (

DISTINCTCOUNT(trx_diario[merchant_id]),

FILTER(ALLEXCEPT(trx_diario,trx_diario[Trunc dia_venta]),

YEAR(trx_diario[dia_venta]) = YEAR(MAX(trx_diario[dia_venta])) &&

MONTH(trx_diario[dia_venta]) = MONTH(MAX(trx_diario[dia_venta])) ),

USERELATIONSHIP(ventas[date], trx_diario[dia_venta]),

FILTER(trx_diario, trx_diario[Canal] IN ALLSELECTED(Canal_venta[Canal]) )

)

Wich produces the next output in a table:

This table is another input to get divided by another table in the same "shape". So, my goal is get this ratio between this 2 measures and get the final table.

But, my ZZZ measure mentioned before is not all OK, because I need to have the grand total columns across all the column values, like in the next image:

I hope there's some easy way to get my desire output because I spent a lot to get the ZZZ measure and feel it need a little change of some way to get my output.

[amitchandak · Accepted solution]

@Anonymous , The screenshot is not showing for ZZZ column?

Need grand total

GT of ZZZ =
CALCULATE (
DISTINCTCOUNT(trx_diario[merchant_id]),
FILTER(ALLEXCEPT(trx_diario,trx_diario[Trunc dia_venta]),
YEAR(trx_diario[dia_venta]) = YEAR(MAX(trx_diario[dia_venta])) &&
MONTH(trx_diario[dia_venta]) = MONTH(MAX(trx_diario[dia_venta])) ),
USERELATIONSHIP(ventas[date], trx_diario[dia_venta]),
FILTER(trx_diario, trx_diario[Canal] IN ALLSELECTED(Canal_venta[Canal]) ) , allselected()
)

DO you need hybrid table

if you are looking for a Hybrid display with Matrix Column and measure
https://community.powerbi.com/t5/Community-Blog/Creating-a-custom-or-hybrid-matrix-in-PowerBI/ba-p/1354591
https://community.powerbi.com/t5/Quick-Measures-Gallery/The-New-Hotness-Custom-Matrix-Hierarchy/m-p/963588#M428

vote for Hybrid Table
https://ideas.powerbi.com/ideas/idea/?ideaid=9bc32b23-1eb1-4e74-8b34-349887b37ebc