cancel
Showing results for
Did you mean:

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a \$100 discount. Register Now

New Member

## 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 :

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
Memorable Member

Hi @SC-A ,

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?

New Member

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

Super User

@SC-A , 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" })
)

New Member

Unfortunately it doesn't work...

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

Announcements

#### Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

#### Power BI Monthly Update - February 2024

Check out the February 2024 Power BI update to learn about new features.

#### Microsoft Fabric Career Hub

Explore career paths and learn resources in Fabric.

#### Microsoft Fabric Partner Community

Engage with the Fabric engineering team, hear of product updates, business opportunities, and resources in the Fabric Partner Community.

Top Solution Authors
Top Kudoed Authors