topic Re: Dax not returning a value in DAX Commands and Tips

Dax not returning a value

David01 — Wed, 11 May 2022 21:53:32 GMT

I am having difficulty getting the following to work any help would be appreciated.

IF( MAX(Machine[Display])="Precision"
,CALCULATE(SUM(Manufacturing[TonnesMade]),Machine[Alt Name] IN {"MA","MB","MC","MD"})
,CALCULATE( SUM(Manufacturing[TonnesMade])))

TRIED

VAR = CALCULATE(SUM(Manufacturing[TonnesMade]),Machine[Alt Name] IN {"MA","MB","MC","MD"})

RETURN
IF( MAX(Machine[Display])="Precision"
,VAR
,CALCULATE( SUM(Manufacturing[TonnesMade])))

If I do the following

IF( MAX(Machine[Display])="Precision"
,12345.01
,CALCULATE( SUM(Manufacturing[TonnesMade])))

It returns the 12345.01 for Precision otherwise it wont even show Precision.

All other results are shown as expected for any of the variations I have tried.

The CALCULATE(SUM(Manufacturing[TonnesMade]),Machine[Alt Name] IN {"MA","MB","MC","MD"}) does return a value if i use it in a card as a test

the table Manufacturing and Machine have a relationship one to many.

Re: Dax not returning a value

amitchandak — Thu, 12 May 2022 07:35:07 GMT

David01 , can share some visual screen shot. the above should work

Try this too

CALCULATE(SUM(Manufacturing[TonnesMade]),Filter(Machine, Machine[Alt Name] IN {"MA","MB","MC","MD"}) )

Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.

Re: Dax not returning a value

David01 — Fri, 13 May 2022 02:00:58 GMT

I changed this
IF( MAX(Machine[Display])="Precision"
,CALCULATE(SUM(Manufacturing[TonnesMade]),Machine[Alt Name] IN {"MA","MB","MC","MD"})
,CALCULATE( SUM(Manufacturing[TonnesMade])))

To

IF( MAX(Machine[Display])="Precision"
,CALCULATE(SUM(Manufacturing[TonnesMade]),Machine[Alt Name] IN {"MA","MB","MC","MD"},

allexcept(Machine,Machine[Alt Name])

)
,CALCULATE( SUM(Manufacturing[TonnesMade])))

It now works as I required.

I will be the first to acknowledge I have no idea what the allexcept is acually doing.

Thanks for looking at this for me.