User Profile
gmq
Frequent Visitor
Joined 5 years ago
User Widgets
Contributions
Re: Calculated table on fact table
Hi Anonymous , Thanks so much for your assistance, I can't believe the answer could be so simple. However, when testing it in our Production environment, I realised I only have a direct query mode, as such I don't have access to the data pane. Is there a way to create the calculated table in the report view? Alternatively, I should be able to create it Tabular Editor, just not sure how yet... So far I've created two measures L_NC_Soup_Table = FILTER(LoyaltyMemberTransactionItem, LoyaltyMemberTransactionItem[LoylatyTransactionCounter]=1 && // can edit this to see other order counter RELATED('Product'[Product Category])="Soup") And L_NC_Soup = CALCULATE( COUNTROWS(LoyaltyMemberTransactionItem), FILTER(LoyaltyMemberTransactionItem, LoyaltyMemberTransactionItem[LoyaltyMemberKey] in VALUES('L_NC_Soup_Table'[LoyaltyMemberKey]) )) But I get an error saying measure L_NC_Soup failed because L_NC_Soup_Table cannot be found.538Views0likes1CommentCalculated table on fact table
Good day, I'm trying to filter a fact sales item table. I need to extract all the customers' ID based on a product category and order number; in order to analyse their customer behaviour (i.e. what they purchased on their 2,3,4,5 etc. orders). I believe I need to use a calculated table and filter the sales item fact table, but honestly it is a little out of my depth, can anyone give me a few pointers so that I can educate myself? The model contains several tables but I think we can focus on two for this to work. Dim_products: Contains PLU (basically SKU) and Product Category. I need to filter for product category = 'pizza' Sales_Item: Contains Customer ID, Transaction_Counter (as in first, second third customer order), PLU. In my mind what I want is: 1. if Transaction_Counter=1 and PLU(related)=soups; then give me the customer ID 2. filter sales item using said subset of customers 3. use the existing visuals to measure the sales mix across the following orders Can anyone point me in the right direction? Thanks! Not sure if it is relevant, the model is import mode, but I'm working on desktop, so I can't directly change the table structure and need to manage via DAX. A Dim_Customer table exists, but I don't think it is necessary for this exercise, do let me know if I'm mistakenSolved609Views0likes3CommentsRe: Power BI and Dataflows
Hi Amine, thank you so much for your replay, this helps clarify a lot. But I still struggle to understand whether if I am able to host an small azure data lake storage for a few data flows using my power bi pro/premium license. In a way that would enable me to test and showcase the whole power of cloud storing, schedule refresh, interactive power bi viz to name a few. Would you agree that can be done ? Thanks979Views0likes1CommentPower BI and Dataflows
Apologies if this is not the right section. I am somewhat new to this fascinating tool and still have to get around all the existing and new capabilities that keep getting released in the blink of an eye. I would love to be able to extract from Quickbooks Commerce + Shopify + Google sheets, I am almost positive I could do the ETL process using Power Query. To my understanding, would data flow enable me to connect to the cloud SaaS, ETL them and load to some sort of 'free' azure cloud data lake ? (we currently don't have a Data Lake / Warehouse and I could use this 'test/prototype' to showcase at least one thing that can be done with cloud storage ) To give you a little bit of background currently I got tangled in a painstaking process where I export standard reports from Quickbooks + Shopify, save them on my local drive and then the Power bi model kicks in by loading the folder, and I would very much like not only automate that, but extract data from those softwares that I am currently unable (i.e. in QBC historic inventory costs on every date) Hope the message makes sense, and thanks everyone for making this forum great.1KViews0likes4CommentsMatriz personalizada - utilizando columnas y/o medidas calculadas
Por alguna razón mi post anterior se eliminó... De todos modos He estado trabajando con algunos datos y finalmente encontrar una manera de poner en marcha las medidas, mis objetos visuales se ven bien, pero no puedo crear esta matriz de resumen comparando diferentes medidas en la misma columna Tengo los datos iniciales, Escenario A (calculado dentro de PowerBI) y escenario B (Uso del parámetro what if) Estoy buscando crear una matriz como esta, sin embargo los ingresos brutos de datos iniciales son una medida/columna, escenario Un ingreso bruto es otra medida/columna y el escenario B es otra medida (no hay columna aquí ya que se hizo usando lo que parámetro) Ingresos brutos Ingresos netos Margen bruto Margen bruto % GR Diff NR Diff $ GM Diff % GR Ser % NR Var % GM Var Datos iniciales 9,700,000 9,000,000 3,000,000 33% Escenario A 10,670,000 9,970,000 3,970,000 40% 970,000 970,000 970,000 10.0% 10.8% 32.3% Escenario B 11,155,000 10,455,000 4,455,000 43% 1,455,000 1,455,000 1,455,000 15.0% 16.2% 48.5% Espero im ser lo suficientemente claro, la verdad se dice que ni siquiera sé si puedo crear esto en power bi y tal vez debería seguir exportando y trabajando en excel... No he usado DAX mucho, así que ten paciencia conmigo en este... gracias de antemano!503Views0likes3CommentsCustom Matrix - using calculated columns and/or measures
For some reason my previous post got deleted... Anyway I have been working with some data and finally figure a way to get the measures going, my visuals look good but i cannot create this summary matrix comparing different measures on the same column I have the initial data, Scenario A (calculated within PowerBI) and scenario B (Using what if parameter) Im looking to create a matrix like this, however Initial data gross revenue is one measure/column, scenario A gross revenue is another measure/column and scenario B is yet another measure (no column here since it was made using what it parameter) Gross Revenue Net Revenue Gross Margin Gross Margin % $ GR Diff $ NR Diff $ GM Diff % GR Var % NR Var % GM Var Initial Data 9,700,000 9,000,000 3,000,000 33% Scenario A 10,670,000 9,970,000 3,970,000 40% 970,000 970,000 970,000 10.0% 10.8% 32.3% Scenario B 11,155,000 10,455,000 4,455,000 43% 1,455,000 1,455,000 1,455,000 15.0% 16.2% 48.5% Hope im being clear enough, truth be told i dont even know if i can create this in power bi and perhaps i should keep exporting and working on excel... I haven't used DAX a lot so bear with me on this one... thanks in advance!609Views0likes3CommentsRe: Gráfico de cascada de Power BI con visual personalizado / Medidas con 3 columnas en lugar de solo 1
mis dos centavos aquí... usando "cascada simple" (búscala en 'obtener más visuales') puede seleccionar un valor y "definir como pilar" que funciona exactamente como excel "establecer como total" aparentemente no tengo permisos para subir imagen... lo siento bout que3.2KViews0likes0CommentsRe: Power BI Waterfall Chart with Custom Visual / Measures using 3 columns instead of just 1
my two cents here... using "simple waterfall" (look for it in 'get more visuals') you can select a value and "define as pillar" which works exactly as excel "set as total" apparently i dont have permissions to upload image...sorry bout that21KViews0likes0CommentsDifferent levels of aggregation
Hi Guys I have a Table with SKU's and Customers, now these two have different levels of aggregation i.e. Customer Groups, product hierarchy and I sometimes need one sometimes another i.e. Sales volume per customer group, avg price per product hierarchy Right now I'm using groupby and excel workarounds modifying the data source, but there's gotta be another way I'm not seeing... The final output would be something along the lines as: customer group with the highest volume on each sku * (Current Customer group volume / Highest volume). That for each sku and customer number. A per my limited knowledge right now, i see no possible solution on the short run... Any clues as to where i should aim my future google searches ?Solved2.9KViews0likes2Comments
Data Privacy
Microsoft Fabric Community and Privacy
To learn more about how we manage your data, please review the Microsoft Fabric Community Data Privacy guide.