Hi, i need help! I have the follow measure: REAL = CALCULATE( sum(BA_DIARIO[VLR_LANCAMENTO])/1000000, LASTDATE(BA_DIARIO[DT_EXEC]) ) This one works fine and do what i need properly. The issue comes now. I try to use them in the code like bellow: Sum Switch = SWITCH ( TRUE(), SELECTEDVALUE ( BA_DIARIO[DC] ) = "△ REAL X BN", [REAL], SUM ( BA_DIARIO[VLR_LANCAMENTO] )/1000000 ) it aways returns the sum of else statement. Yes, i tested swap that measure [REAL] in SELECTEDVALUE ( BA_DIARIO[DC] ) = "△ REAL X BN", [REAL] by SELECTEDVALUE ( BA_DIARIO[DC] ) = "△ REAL X BN", 0 And worked, returns 0 in "△ REAL X BN". What i do?

Anonymous Ok, it's more clear. So try with create a new calculated table:DC_TABLE = DISTINCT(BA_DIARIO[DC])you have to relate this table with BA_DIARIO and use this new table as column in the matrix. Then create another new table:DT_TABLE = DISTINCT(BA_DIARIO[DT_EXEC])but DON'T relate this new one with BA_DIARIO.Then calculate measure like:Sum Switch = VAR BN6 = CALCULATE(SUM(BA_DIARIO[VLR_LANCAMENTO]) / 1000000, DC_TABLE[BA_DIARIO_DC] = "BN 6 + 6")VAR MAXDTEXEC = MAX(DT_TABLE[DT_EXEC])VAR DCMAXEXEC = CALCULATE(SUM(BA_DIARIO[VLR_LANCAMENTO]) /1000000, BA_DIARIO[DT_EXEC] = MAXDTEXEC, ALL(DC_TABLE))VAR CALC =IF(SELECTEDVALUE (DC_TABLE[BA_DIARIO_DC] ) = "△ REAL X BN", BN6 - DCMAXEXEC, SUM(BA_DIARIO[VLR_LANCAMENTO]) / 1000000)RETURN CALC and you achieve the output: BBF

Measure doesn't working with selectedvalue | Microsoft Fabric Community

Forum Discussion

Related content

Using SelectedValue in measure for computing volume

Use selectedvalue in a measure

SelectedValue Measure DAX not working

Selectedvalue

SELECTEDVALUE measure from slicer keeps returning blank value when used on another measure