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.
Hello
I have 2 tables a client table and a master table that are related. I want to calculate the number of clients thats $ is over 1M. I cant seem to get it, here are some example codes that dont work
CALCULATE(DISTINCTCOUNT('ClientTable'[ClientName]), MasterTable[$] > 1000000) This results in just the total number of clients in the data.
CALCULATE(DISTINCTCOUNT('ClientTable'[ClientName]), FILTER('MasterTable, CALCULATE(SUM('MASTERTABLE'[$]) >= 1000000))))
CALCULATE(DISTINCTCOUNT('ClientTable'[ClientName]), Filter(MasterTable, Calculate(sum(MasterTableJ[$]), allexcept(clienttable, masterclientname)) >= 1000000))
I even tried using a measure
IFMeasure = IF(SUM(MasterTable[$]) > 1000000, 1, 0)
Actual Measure = CALCULATE(DISTINCTCOUNT('ClientTable'[ClientName]),FILTER('MasterTable', 'IFMeasure'[1M] = 1))
Anyone have any examples/solution to this?
Hi,
Please check the below picture and the attached pbix file.
All measures are in the attached pbix file.
Clients count over 1600 : =
COUNTROWS ( FILTER ( Clients, [Sales :] > 1600 ) )
My $ and client are on two different tables. Also the table with the $ is based off individuals not clients. The tables are related.
Check out the July 2025 Power BI update to learn about new features.
User | Count |
---|---|
24 | |
9 | |
7 | |
6 | |
6 |
User | Count |
---|---|
29 | |
11 | |
11 | |
10 | |
6 |