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.
Hello, I need to add the values that are marked in the column to the side. The column "New Bimonthly Customers" derives from a measure created:
Solved! Go to Solution.
Hi Diego
Not sure if I fully understand but you may try this
Valor Clientes Bimestrais =
SUMX (
VALUES ( SBOPRODMS[Nome do PN] ),
IF ( [Novos Clientes Bimestrais] = 1, [Valor NET | NF] )
)
Hi Diego
Not sure if I fully understand but you may try this
Valor Clientes Bimestrais =
SUMX (
VALUES ( SBOPRODMS[Nome do PN] ),
IF ( [Novos Clientes Bimestrais] = 1, [Valor NET | NF] )
)
Perfect. Is correct !! I will use the same for New Semiannual Customers.
I was wrong when using the Bimonthly New Customers measure within SUMX. It was giving placeholder error.
I have another question, but I'll open it in another message here on the forum. Thank you one more time.
Add up according to the clients that are marked as bimonthly. Sorry, I use google translate
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 |
---|---|
47 | |
24 | |
20 | |
15 | |
13 |
User | Count |
---|---|
55 | |
48 | |
43 | |
19 | |
19 |