topic Re: Somases com varíavel dinâmica in DAX Commands and Tips

Somases com varíavel dinâmica

andreruiz7 — Thu, 01 Feb 2024 15:26:18 GMT

preciso executar a soma de valores correspondentes a ele próprio, dentro do referido mês.

como a metragem e contabilizada individualmente por SUC, preciso de uma fórmula que faça com que estes valores sejam os seus totais naquele mês.

exemplo: qual a metragem total da Loja X dentro do mês de Dezembro?

lembrando que o valor tanto do "nome fantasia" e "mes ano" é variável, então deve ser feita a leitura individualmente, linha a linha.

é possível fazer dentro do Power BI?

Re: Somases com varíavel dinâmica

Anonymous — Fri, 02 Feb 2024 02:45:26 GMT

Hi, andreruiz7

I'm happy to answer your questions. We can use measure and slicer to find the total area of a certain product in a certain month.

Sample data:

Click here to create measure:

The DAX formula of measure is as follows:

Measure = CALCULATE(SUMX('Tabelle1','Tabelle1'[ABL Ajustada]+'Tabelle1'[ABL(m2)]),'Tabelle1')

We can use card visual to reflect the total area:

Dynamically calculate the total area of the asdf store in December through slicer:

The dynamic calculation results are as follows: For example, the total area of the asdf store in December =969.2+108+969.2+84+969.2+108=3207.6:

I have provided my PBIX file below. If this helps you, that would be great.

How to Get Your Question Answered Quickly

If it does not help, please provide more details with your desired output and pbix file without privacy information (or some sample data) .

Best Regards

Jianpeng Li

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

Re: Somases com varíavel dinâmica

andreruiz7 — Fri, 02 Feb 2024 12:45:49 GMT

Jianpeng, thanks for your answer

actually, the solution is a little bit more complex... i will show you my original "problem":

basically, i have a filter that have to find the square footage (ABL) between an range

but, the power BI logic search is individually by each SUC (its a name gave to the storage that is occupied). so when this filter is applied, i dont find the result, because this storage has multiple SUCs

which is 3 SUCs that combined have 176m².

so, in that case, the filter works only when i put the minimun range in 48m², which make the final analysys wrong...

thats why in trying to create an "fit square footage" column. The fórmula need to SUM the Square Footage(ABL) in total for the following month, so i can use as a value in my table and correctely be filtered in the selected range.

Re: Somases com varíavel dinâmica

andreruiz7 — Tue, 06 Feb 2024 18:01:40 GMT

Hello

someone can help me?