Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.
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]?
Proud to be a Super User!
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?
Check out the November 2023 Power BI update to learn about new features.
Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.