Create measures grouping by two columns with the same values and using filters
Hi folks, I'm new in Power Bi but I have worked with QlikView. Now, I'm trying to developer a desktop solution that requires create two count measures based in two different columns with the same value. In pratice, I have a table with my sales records that contains the sale_date an the sale_deluveyr. Based on it, i need construct a summary table with the distinct dates on the rows, one column with the count of sales happened and another column with the count of sales delivered. In addition this, I need to maintain filters from another column of my original table. Above an image of what I need.