Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
nanutum
Helper I
Helper I

Condition if in table power pivot problem

 

i used Power pivot and want to add condition if in table then relationship table have problem


Problem in RED ZONE

 

when i used condition if table have problem

 

sorry about my english

AED.PNG

3 REPLIES 3
MFelix
Super User
Super User

Hi @nanutum,

 

The question is that in power pivot the blanks is not equal to 0 you need to do something like this

 

if (
     [%ACH] = "",
     0,
        if ([%ACH] >= "1,
            5000,
            0
            )
  )

Regards,

MFelix


Regards

Miguel Félix


Did I answer your question? Mark my post as a solution!

Proud to be a Super User!

Check out my blog: Power BI em Português



hi @MFelix

 

My Problem is 4,5,6 in "B" when i used condition if 4,5,6 show in "A" Why ?

Hi @nanutum,

 

Can you post a sample of your data and the final result you want to achieve?

 

Regards,

MFelix


Regards

Miguel Félix


Did I answer your question? Mark my post as a solution!

Proud to be a Super User!

Check out my blog: Power BI em Português



Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.