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

The Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.

Reply
Anonymous
Not applicable

DAX FORMULE NEED HELP PLEASE

bonjour tout le monde,

 

J'ai fais une formule qui dois tester mes valeurs dans certaines colonnes pour savoir si elles sont vide ou non. 

Si une valeur est vide dans une colonne, alors je vais tester pour recuperer la valeur et si dans cette colonne il n'y a pas de valeur, je vais tester dans une dernière colonne.

Mais ma fomule me renvoie aucun résultat : 

SCA_0-1660732401107.png

Voici ma formule :

CALC PROV =
if(sum('KPI 06 - Cost Control extractio'[MTN FEES RPT]) = 0,
calculate(sum('KPI 06 - Cost Control extractio'[CTUAMOUNT]),
'KPI 06 - Cost Control extractio'[COD STA] IN { "PI" }),
if(sum('KPI 06 - Cost Control extractio'[CTUAMOUNT]) = 0,
calculate(SUM('Extract SAP du 01-07 au 31-07-2'[Valeur condition]),'KPI 06 - Cost Control extractio'[COD STA] IN { "PI" })))
 
Merci d'avance de votre aide 🙂
4 REPLIES 4
davehus
Memorable Member
Memorable Member

Hi @Anonymous ,

 

Is this the exact formula as it will not work based on how it's written. Are value columns in your table straight from the data source or calculated measures?

 

Did I help you today? Please accept my solution and hit the Kudos button.

Anonymous
Not applicable

it's the exact formula and the value are straight from the data source 

@Anonymous , I you checking for blank or 0, see if this can help

 

Switch ( True() ,
isblank(sum('KPI 06 - Cost Control extractio'[MTN FEES RPT]) ) || sum('KPI 06 - Cost Control extractio'[MTN FEES RPT]) = 0 ,calculate(sum('KPI 06 - Cost Control extractio'[CTUAMOUNT]),
'KPI 06 - Cost Control extractio'[COD STA] IN { "PI" }) ,
isblank(sum('KPI 06 - Cost Control extractio'[CTUAMOUNT])) || sum('KPI 06 - Cost Control extractio'[CTUAMOUNT]) =0 ,
calculate(SUM('Extract SAP du 01-07 au 31-07-2'[Valeur condition]),'KPI 06 - Cost Control extractio'[COD STA] IN { "PI" })
)

Full Power BI Video 20 Hours YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube
Anonymous
Not applicable

Unfortunately it doesn't work...

SCA_0-1660740744967.png

 

The goal of this formula is to check if in a ligne of a column there's a blank value and change this value to an other one from a other column

Helpful resources

Announcements
Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

Jan NL Carousel

Fabric Community Update - January 2025

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