Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
@Anonymous
So again.. it's a measure. Please try
=
SUMX (
VALUES ( 'Customers'[Store Names] ),
DIVIDE (
[Custom $ Sales],
CALCULATE ( [Sales of the total market], ALL ( 'Customers' ) )
) * 100
)
Hi @Anonymous
What do have on the rows of your table/matrix visual? How many source data tables are involved in the two measures? what is the dax for both measures?
So for Custom $ Sales, I've created this measure to bring Sales from all my customers. There's just one source table for the Custom $ sales, and then sales of the total market is also it's own measure in the table.
My retailer names come from table: 'Customers'[Store Names], Custom $ sales is 'Sales'[Custom $ Sales] and then Sales of the total market is from 'Sales'[Sales of the total market]
@Anonymous
Please try
=
SUMX (
VALUES ( 'Customers'[Store Names] ),
DIVIDE (
CALCULATE ( SUM ( 'Sales'[Custom $ Sales] ) ),
CALCULATE ( SUM ( 'Sales'[Sales of the total market] ), ALL ( 'Customers' ) )
) * 100
)
Hey! I tried this, but for the 'Sales'[Custom $ Sales] it says they're not the right parameter... I created these measures within 'Sales'
@Anonymous
So again.. it's a measure. Please try
=
SUMX (
VALUES ( 'Customers'[Store Names] ),
DIVIDE (
[Custom $ Sales],
CALCULATE ( [Sales of the total market], ALL ( 'Customers' ) )
) * 100
)
hello @Anonymous ,
you can use the following:
Your measure = (SUM(table[Custom Sales]) / CALCULATE(SUM(table[Custom Sales]),ALL(table)))) * 100
Check out the July 2025 Power BI update to learn about new features.
User | Count |
---|---|
25 | |
10 | |
7 | |
6 | |
6 |
User | Count |
---|---|
30 | |
11 | |
11 | |
10 | |
6 |