Calculate and IF

[Anonymous]

Hello,

well maybe its impossible but... but here my idea:

I have 2 Tables

• model with layerID
• datasocurce with layerID and costs

layerID are divided i 2 types

• normal
• aggregation (usualy sum of normal or other aggregations)

what i´m looking for

• have 1 table and have in 1 column the results (costs by layers, normal and aggreation)
• ... well i know how to make this work in many many tables, but this isnt my task

well my idea is

=
IF layerID = 100 then calculate () // first aggreation 

IF layerID = 200 then calculate () // second aggreation 

...

ELSE calculate(sum(datasource[costs]), model[layerID])

can it work?

[amitchandak · Accepted solution]

@Anonymous , a measure like

if(max(layerID) = 100, calculate (),calculate ())

or

sumx(summarize(table,table[layerID],"_1",if(max(layerID) = 100, calculate (),calculate ()) ),[_1])

[Anonymous]

@amitchandak 
first ofall thank You, but if i try...

Measure =

if(max(_Modell[VerdichtungsId])=100,

CALCULATE(1+1+1)

, CALCULATE(SUM(FactPlan[Saldo-Plan]),FactPlan[VerdichtungsId]))

then i get back 3 - korrekt, but if i try

Measure =

if(max(_Modell[VerdichtungsId])=100,

CALCULATE(SUM(FactPlan[Saldo-Plan]),FactPlan[VerdichtungsId]=101)

, CALCULATE(SUM(FactPlan[Saldo-Plan]),FactPlan[VerdichtungsId]))

then i get back EMPTY ("")...

btw. Results in ELSE are korrekt

What is my mistake?

[Anonymous]

😄

found my error: "..., Filter(Allselected(Table), Table(ID)=IdNr)..."

ty

[harshnathani]

Hi @Anonymous ,

Try using RELATED function.

https://docs.microsoft.com/en-us/dax/related-function-dax

and the the SWITCH function

https://dax.guide/switch/

Also,

share sample data of your tables and expected output to help you better.

Regards,
Harsh Nathani

Did I answer your question? Mark my post as a solution! Appreciate with a Kudos!! (Click the Thumbs Up Button)