% of total columns

[Syndicate_Admin]

Good afternoon, how are you? I need your help. I have a measure that calculates the number of units sold with some restrictions:

calculate([Billed Units],

FILTER(Fact_DetalleListasDePrecios, [Price list items]> 0),

DIM_Articulos[Validity Code] = "1",

FILTER(FACT_Facturacion, [Billed Units] >0))

Based on that measurement, you would need to be able to calculate the % of the column total. I can't use the formula that Power BI desktop comes with because I need to multiply the result of this measure later.

The measure should look something like this:

The problem is that the ALL() filter is not taking me into account, so the result it shows me is this:

Could someone help me understand why you are not taking ALL into account.

Thank you!

Federico

[lbendlin]

You cannot measure a measure directly. Either materialize it first, or create a separate measure that implements the entire business logic.

Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).

Do not include sensitive information or anything not related to the issue or question.

If you are unsure how to upload data please refer to https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-...

Please show the expected outcome based on the sample data you provided.

Want faster answers? https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447...