Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi everybody!
I have these three tables: VR connected with Articles by Codigo, and VR with Clientes by CodCliente.
I want to count how many brands has each "CodClient", but it must have a postive sell. I tried to do it with a new table using:
CountBrands = summarize(VR,VR[CodCliente],Calendario[Year],Calendario[Month],"Cant marcas",DISTINCTCOUNT(Articles[Brand]),"Total Sales", SUM(Vr[Sales]))
(Calendario is an auxiliary calendar table.)
After that, I do a new measure
FinalMeasure = Calculate(AVERAGE(CountBrands'Cant Marcas'), CountBrands'Total Sales'>0)
And it seems to work, but i would like to do it in a measure, rather than a new table, but im not sure how to do it.
What do you recommend to me?
Thanks you all!
Compute the total sales for each brand and count how many of those are positive:
CountBrands =
VAR BrandSummary =
ADDCOLUMNS (
VALUES ( Articles[Brand] ),
"@SumSales", CALCULATE ( SUM ( VR[Sales] ) )
)
RETURN
COUNTROWS ( FILTER ( BrandSummary, [@SumSales] > 0 ) )
Edit: It might be even simpler to write like this:
CountBrands =
COUNTROWS (
FILTER ( VALUES ( Articles[Brand] ), CALCULATE ( SUM ( VR[Sales] ) ) > 0 )
)
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
44 | |
28 | |
23 | |
12 | |
8 |
User | Count |
---|---|
74 | |
51 | |
45 | |
16 | |
12 |