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 need to write a measure to do the following query.
SELECT count(*)
FROM table 1 a
WHERE a.code IN
(select b.code from table 2 b where b.id = selectedvalue(table3[id])
Appreciate any help/suggestions, Thank you!
Solved! Go to Solution.
Hi @Elichka
Have you solved your problem? If so, can you share your solution here and mark the correct answer as a standard answer to help other members find it faster? Thank you very much for your kind cooperation!
Best Regards
Zhengdong Xu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Try this measure out
SelectedCount =
VAR SelectedID = SELECTEDVALUE(Table3[id])
VAR FilteredCodes =
CALCULATETABLE(
VALUES(Table2[code]),
Table2[id] = SelectedID
)
RETURN
CALCULATE(
COUNTROWS(Table1),
Table1[code] IN FilteredCodes
)
Thanks for a quick respond! When tried your solution it took loong time and got a message "Couldn't load the data for this visual". Table1 has more than 10 mln records and I have filters for visuals on the page. May be I need to add filters to the measure also? If you can add to your solution for table1 source_id = 1 and service_id = 2 ? Many thanks!
I tried to refactor the DAX
SelectedCount =
VAR SelectedID = SELECTEDVALUE(Table3[id])
RETURN
CALCULATE(
COUNTROWS(Table1),
FILTER(
Table1,
Table1[code] IN
CALCULATETABLE(
VALUES(Table2[code]),
Table2[id] = SelectedID
)
)
)
Thanks! I tried refactor measure and got nothing unfortunately...
Hi @Elichka
Have you solved your problem? If so, can you share your solution here and mark the correct answer as a standard answer to help other members find it faster? Thank you very much for your kind cooperation!
Best Regards
Zhengdong Xu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Check out the July 2025 Power BI update to learn about new features.
User | Count |
---|---|
23 | |
8 | |
7 | |
6 | |
6 |
User | Count |
---|---|
28 | |
11 | |
11 | |
10 | |
6 |