Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
Hello everyone !!
I´ve being in trouble with this.
The objective is to know how many ( in porcentage ) one "vendedor" sold of the product called in the " linha " column compared to the total sold by the Loja 1 in the " nome loja " column.
So i can filter the result by the column ( nome loja ), by the column ( linha ), and by the column ( vendedor ) and get the percentage of the column "vendedor" compared to the whole " linha " column and with the " nome loja " column.
With that i may now the percentage one "vendedor" sold of one specific product " linha " compared as the total of " linha " sold by the loja 1, column " nome loja ".
I´ve tryed so far to create a new column using the calculate formula. But it returns an error as the column "linha" is text and not numbers.
If i could filter the result of the sum of the "qtde de itens" and the "% qtde de itens" using the other text columns i will be able to do the rest easy.
Thanks in advance.
Please help confirm if understand your requirement correctly.
For example, Vendor_1 sold thirty Linha_1 products, Vendor_2 sold seventy Linha_1 products. Linha_1 product is not sold by other Vendors. Totally one thousand Linha products were sold by LOJA_1. So we can get below two different percentages.
If my understanding is correct, please refer to following steps:
Vendedor_Sales = CALCULATE ( SUM ( PRODUTOS[Qtde de Itens] ) )
Loja_Sales_Of_All_Linha = CALCULATE ( SUM ( PRODUTOS[Qtde de Itens] ), ALL ( PRODUTOS ) ) Loja_Sales_Of_Specific_Linha = CALCULATE ( SUM ( PRODUTOS[Qtde de Itens] ), ALLEXCEPT ( PRODUTOS, PRODUTOS[Linha] ) )
%_VendedorSales_vs_LojaSales_All_Linha = DIVIDE ( [Vendedor_Sales], [Loja_Sales_Of_All_Linha] ) %_VendedorSales_vs_LojaSales_Specific_Linha = DIVIDE ( [Vendedor_Sales], [Loja_Sales_Of_Specific_Linha] )
Any news on this topic please?
Create this measures
qItems-Linha = CALCULATE(sum(PRODUCTOS[QItems]))
%Qitems = DIVIDE([qItems-Linha];CALCULATE(sum(PRODUCTOS[QItems]);ALL(PRODUCTOS[Linha])))
I hope this help