Hi there, I am just a starting PowerBi user and I have a question about how to calculate the unique number of partners with more than 10k revenue. Model: Table "Products", with columns [ProductID], [ProductGroup] and more Table "Invoicelines" , with columns [ProductID], [Revenue], [InvoiceID] Table "Invoiceheader", with columns [InvoiceID], [PartnerID], [Date] Table "Date", with all kind of Datecolumns like Period, Quarter, Dayindex, etc. Table "Target" with columns [Quarter], [Target] The tables are linked.
From one of our vendors, we receive 6 different targets. I already managed to make 5 targets and the realization of them visible in PowerBi. But with one I am struggling. Target: X Partners with a minimum of 25k revenue a quarter.
Now I have made a visual with a matrix, where the first field is the period [quarter] and the second field is the target. I need a third field which has a measure with the number of unique partners with more than 25k revenue, where the product group contains "DT" (products in these product groups (DT5460, DT4310 etc) are of this specific vendor). And I hope that because the period is in the Matrix the measure will apply to the period. Can somebody please help me where to start.