Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hello, I managed to get the following measure
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.
Solved! Go to 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
@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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
112 | |
99 | |
73 | |
72 | |
49 |
User | Count |
---|---|
145 | |
109 | |
109 | |
90 | |
64 |