Forum Discussion
Anonymous
2 years agoNot applicable
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])...
- Anonymous2 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.
Anonymous
2 years agoNot applicable
Thats works like I want too, thanks for the help 😄