Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Calling all Data Engineers! Fabric Data Engineer (Exam DP-700) live sessions are back! Starting October 16th. Sign up.

View discussion in a popup

Replying to:

Hi lbendlin I have tried comlete business scenario in one measure without using the [check month wise]  but still I am not able to filtering the Subtotal and Total level .Please help me 


23 Qty Blank Values Only = var _23 Qty = calculate(sum(Financial data(QTY),
                                                                         Financial data[Year]=2023
                                   var _22 Qty = calculate(sum(Financial data(QTY),

                                                                       Financial data[Year]=2022
Return
            If(Not(Isblank(_23 Qty)&&Not(Isblank(_22 Qty),_23 Qty,0)