Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

SELECTECTVALUE not working fine.

  This one have 3 cards with 3 different measures. The first one is : Qtd Total Current Month = CALCULATE(     SUM(LinhasEncomendas_BI[partes]),     MONTH(LinhasEncomendas_BI[DataFinal])...
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi Anonymous 

    You can refer to the following measure

    Qtd Total Current Month =
    CALCULATE (
        SUM ( LinhasEncomendas_BI[partes] ),
        MONTH ( LinhasEncomendas_BI[DataFinal] )
            = IF (
                ISBLANK ( SELECTEDVALUE ( LinhasEncomendas_BI[DataFinal].[MonthNo] ) ),
                MONTH ( TODAY () ),
                SELECTEDVALUE ( LinhasEncomendas_BI[DataFinal].[MonthNo] )
            ),
        ALL ( LinhasEncomendas_BI )
    )
    
    Qtd Total Previous Month =
    CALCULATE (
        SUM ( LinhasEncomendas_BI[partes] ),
        MONTH ( LinhasEncomendas_BI[DataFinal] )
            = IF (
                ISBLANK ( SELECTEDVALUE ( LinhasEncomendas_BI[DataFinal].[MonthNo] ) ),
                MONTH ( EDATE ( TODAY (), -1 ) ),
                MONTH ( EDATE ( SELECTEDVALUE ( LinhasEncomendas_BI[DataFinal].[Date] ), -1 ) )
            ),
        ALL ( LinhasEncomendas_BI )
    )
    
    Qtd Total Previous Month =
    CALCULATE (
        SUM ( LinhasEncomendas_BI[partes] ),
        MONTH ( LinhasEncomendas_BI[DataFinal] )
            = IF (
                ISBLANK ( SELECTEDVALUE ( LinhasEncomendas_BI[DataFinal].[MonthNo] ) ),
                MONTH ( EDATE ( TODAY (), -2 ) ),
                MONTH ( EDATE ( SELECTEDVALUE ( LinhasEncomendas_BI[DataFinal].[Date] ), -2 ) )
            ),
        ALL ( LinhasEncomendas_BI )
    )
    

    Best Regards!

    Yolo Zhu

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.