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.
Please try this:
Measure = IF ( SELECTEDVALUE ( Table[Ind] ) = 0, [Functional Amt], [Transactional Amt] )
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.
130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.