Forum Discussion
DAX expression - nested Ifs or variables?
UPDATED** I am looking for an efficient way to accomplish the following sudo in DAX measure in Power BI, any help would be appreciated! measure = If Table1 column1 = "Term1" Then Table2 Coloum1...
Tried Switch True and reeived the following error "swith does not support comparing values of type True/False with values of type Text
RequiredTests =
VAR FreqType = SELECTEDVALUE(AccActionOptionRateFreqs[FrequencyType])
Return
SWITCH (
TRUE(),
FreqType, "Quantity", SUMX(ContractItems, ContractItems[CurrentQuantity]) * SUMX(ContractProjectItemMaterialSetMaterials, ContractProjectItemMaterialSetMaterials[ConversionFactor]),
FreqType, "Contract", SUMX(AccActionOptionRateFreqs, AccActionOptionRateFreqs[ActionRate]) * SUMX(AccActionOptionRateFreqs, AccActionOptionRateFreqs[ActionFrequency]),
FreqType, "Temporal", "x")