Power BI is turning 10, and we’re marking the occasion with a special community challenge. Use your creativity to tell a story, uncover trends, or highlight something unexpected.
Get startedJoin us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.
Hi,
I have two measures,
Functional Amt - SUM(FA),
Transactional Amt = SUM(TA)
It works fine when I use these measures directly in visuals. However, it isn't working when I use the below measure,
IF(Ind =0, Functional Amt,Transactional Amt)
Getting Error Message:
The resultset of a query to external data source has exceeded the maximum allowed size of '1000000' rows
Kindly assist me.
Solved! Go to Solution.
I tried this. But it's not working.
I have achieved this using bookmarks.
Thanks,
Siva
what's the syntax for [Ind]?
It's just a number in a table,
Name | Ind |
TA | 0 |
FA | 1 |
RA | 2 |
Hi @SivaMani,
Please try this:
Measure = IF ( SELECTEDVALUE ( Table[Ind] ) = 0, [Functional Amt], [Transactional Amt] )
Best regards,
Yuliana Gu
I tried this. But it's not working.
I have achieved this using bookmarks.
Thanks,
Siva
how did you use bookmarks?
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Check out the June 2025 Power BI update to learn about new features.
User | Count |
---|---|
72 | |
69 | |
57 | |
37 | |
36 |
User | Count |
---|---|
85 | |
65 | |
60 | |
46 | |
45 |