Help - Measure in IF Dax don't show total

[fabiofurlanbr]

Hello , please i need your help for the question below.

I need show the total for the measure (calcular_qtd_lic_backup) , but i couldn't.

Thanks  a lot

calcular_qtd_lic_backup =

    var _qtd_lic_aplicada =  [calcular_qtd_lic_aplic]

    var _qtd_lic_nota = SELECTEDVALUE(Merge1[Sistema.1.Quantidade Lic])

    var _compara_lic =

        if( _qtd_lic_nota < _qtd_lic_aplicada,

        0,

        1

    )

    RETURN

    if (_compara_lic = 1 ,

     _qtd_lic_nota - _qtd_lic_aplicada,0

     )

=======

calcular_qtd_lic_aplic =

    var _qtd_lic_aplic = CALCULATE(COUNT(Merge1[Sistema]),

        FILTER(Merge1,Merge1[Sistema.1.Mês_Ref]),

        FILTER(Merge1,Merge1[Lic_Ativa_Desativada]="Ativo")

    )

RETURN

_qtd_lic_aplic

[MohammadLoran25 · Accepted solution]

Hi @fabiofurlanbr ,

I could not understand your fields because of lack of data. But the reason that it happens is for the SELECTEDVALUE function.

Btw, to fix your problem, you can create a new measure below:

NewMeasure =
VAR _TABLEE =
    ADDCOLUMNS ( 'TheTableyouwant', "@BackupMeasure", [calcular_qtd_lic_backup] )
RETURN
    SUMX ( _TABLEE, [@BackupMeasure] )

For the 'TheTableyouwant' you have to insert your desired table. I think you need to use SUMMARIZE function to achieve sth that you have in your table visual.

Then it would give you the desired result.

If this answer solves your problem, give it a thumbs up and accept it as a solution so the others would find what they need easier.

Regards,

Loran

[fabiofurlanbr]

@MohammadLoran25 

Thanks a lot , you're absolutely right, summarize function solved my problem.

Regards