I have a problem that is driving me nuts. Referring to the image attached, I want to calculate column V based on a conditional formula. If there is a value in column A AND column B then calculate value for column V. However, the basic IF statement is not working. Right now, you can see in the totals that column A sums up to 376 and column B sums to 10. The total % for column V (allocation) is 3755%, however, in reality it should only show 100%.
I have achieved something using Summarize but I can not add dates in it so it gives me the total of all values in column A + column B respectively unable to filter by dates.
Can anyone please help me?
Should be something along the lines of:
IF(ISBLANK([ColumnA]) && ISBLANK([ColumnB]), true, false)
Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!: DAX For Humans
DAX is easy, CALCULATE makes DAX hard...
Helpful resources
FabCon Global Hackathon
Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes!
Power BI Monthly Update - October 2025
Check out the October 2025 Power BI update to learn about new features.
FabCon Atlanta 2026
Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
