Use a measure as axys (or summarize by a measure)

[romio]

Hy guys,

I'm on a requirement, that I lost one workday on it, but nothing get progress.

I've a dashboard which makes a "% of use" between some goods and the products that use its to be manufactured.

The end user must be able to filtrer for some products and compare the % of use, between a lot of goods.

This is to find products that share goods between them.

So far, so good, it isn't a complex problem, some DAX and we have the numbers.

But, now, my team would like to COUNT by "% of use" after filter the products.

This is my original measure:

% of use = 
VAR selected_goods =
    COUNTROWS (
        SUMMARIZE (
            T_ESTRUTURA_PAIZAO,
            T_ESTRUTURA_PAIZAO[COD_ITEM_FILHO],
            T_ESTRUTURA_PAIZAO[DESC_ITEM_FILHO],
            T_ESTRUTURA_PAIZAO[DESC_GRUPO],
            T_ESTRUTURA_PAIZAO[COD_ITEM_PAIZAO],
            T_ESTRUTURA_PAIZAO[MASCARA_PAIZAO]
        )
    )
VAR selected_products =
    CALCULATE (
        DISTINCTCOUNT ( T_ESTRUTURA_PAIZAO[MASCARA_PAIZAO] ),
        REMOVEFILTERS ( T_ESTRUTURA_PAIZAO[COD_ITEM_FILHO] )
    )
RETURN
    DIVIDE ( selected_goods, selected_products )

My team expect something like it:

For this, I supposed to use my measure as my axys, but it isn't possible.
Do I have other options to achieve this ?

[amitchandak]

@romio , You need

Dynamic Segmentation Bucketing Binning
https://community.powerbi.com/t5/Quick-Measures-Gallery/Dynamic-Segmentation-Bucketing-Binning/m-p/1...

Dynamic Segmentation, Bucketing or Binning: https://youtu.be/CuczXPj0N-k

As absolute number

Dynamic segmentation -Measure to Dimension conversion: https://youtu.be/gzY40NWJpWQ