cancel
Showing results for
Did you mean:

Re: Measure Totals, The Final Word

Member
538 Views
Highlighted
Member

Re: Measure Totals, The Final Word

AMAZING! thanks to you a lot!

Frequent Visitor

Re: Measure Totals, The Final Word

I'm still trying to get this, and I just cannot wrap my head around it.

Can't find the correct formula to replace "2"

Frequent Visitor

Re: Measure Totals, The Final Word

Nevermind,

This worked:

```Trial =
IF(ISFILTERED(GeneratorNames[GeneratorName])&&ISFILTERED(RunData[Date])&&ISFILTERED(Locations[Location])&&ISFILTERED(IBXs[IBX_Name]),
SUMX(RunData,[Engine Run Time]*SUMX(GeneratorNames,GeneratorNames[FuelRate])),
VAR __table = SUMMARIZE(RunData,Locations[Location],IBXs[IBX_Name],GeneratorNames[GeneratorName],RunData[Date],"__value",SUMX(RunData,[Engine Run Time]*SUMX(GeneratorNames,GeneratorNames[FuelRate])))
RETURN
IF(ISFILTERED(GeneratorNames[GeneratorName])&&ISFILTERED(RunData[Date])&&ISFILTERED(Locations[Location])&&ISFILTERED(IBXs[IBX_Name]),
SUMX(RunData,[Engine Run Time]*SUMX(GeneratorNames,GeneratorNames[FuelRate])),SUMX(__table,[__value])))```
Visitor

Re: Measure Totals, The Final Word

How can one apply this solution to a measure that references two additional measures, as shown below?

Lost Customers = IF([Total Orders]>0 && [Last Period Orders]<=0 ,1,0)

For your reference, below are the details of the two additional measures:
Total Orders = SUMX(RELATEDTABLE('Mfg Invoice Data-Mar'),'Mfg Invoice Data-Mar'[Quantity])

Last Period Orders = CALCULATE(
SUM('Mfg Invoice Data-Mar'[Quantity]),
DATESBETWEEN(
'Mfg Invoice Data-Mar'[Creation Date].[Date],
LASTDATE('Mfg Invoice Data-Mar'[Creation Date].[Date])
)
)

I am trying to show a total of Lost Customers but the total is outputting "1".
Regular Visitor

Re: Measure Totals, The Final Word

very helpfull, but there's something missing for me because doesn't work.

i have this measure

Tot Costo/h = CALCULATE(SUMX(hr_analytic_timesheet;hr_analytic_timesheet[Ore])*MAX('Dipendenti Costo/H'[Costo H]))