Forum Discussion

PuneethERB's avatar
PuneethERB
Frequent Visitor
6 years ago
Solved

Power BI DAX No Data Calculation

Hi All, [Referring to the screenshot] About the data: I've prepared the model where in the 'Date' as seen in the screenshot is an intermediate table and 'Code' is also an intermediate table and the ...
Need Help
Tips and Tricks
  • v-eachen-msft's avatar
    v-eachen-msft
    6 years ago

    Hi PuneethERB ,

     

    You could create two measures.

    Measure =
VAR a =
    PRODUCTX (
        FILTER (
            'Table',
            'Table'[Value] IN { BLANK (), 0 }
                && (
                    CALCULATE ( SUM ( 'Table'[Value] ), ALLEXCEPT ( 'Table', 'Table'[Date] ) ) = 0
                )
        ),
        1
    )
RETURN
    IF (
        NOT ( ISINSCOPE ( 'Table'[Type] ) ) && ISINSCOPE ( 'Table'[Date] )
            && SELECTEDVALUE ( 'Table'[Value] ) IN { BLANK (), 0 },
        a,
        SUM ( 'Table'[Value] )
    )
    Measure new = 
SUMX(VALUES('Table'[Date]),[Measure])

    Then put "Measure new" into Values.

    Here is the result.

    Here is my test file for your reference.

     

v-eachen-msft's avatar
v-eachen-msft
Icon for Community Support rankCommunity Support
6 years ago

Hi PuneethERB ,

 

You could create two measures.

Measure =
VAR a =
    PRODUCTX (
        FILTER (
            'Table',
            'Table'[Value] IN { BLANK (), 0 }
                && (
                    CALCULATE ( SUM ( 'Table'[Value] ), ALLEXCEPT ( 'Table', 'Table'[Date] ) ) = 0
                )
        ),
        1
    )
RETURN
    IF (
        NOT ( ISINSCOPE ( 'Table'[Type] ) ) && ISINSCOPE ( 'Table'[Date] )
            && SELECTEDVALUE ( 'Table'[Value] ) IN { BLANK (), 0 },
        a,
        SUM ( 'Table'[Value] )
    )
Measure new = 
SUMX(VALUES('Table'[Date]),[Measure])

Then put "Measure new" into Values.

Here is the result.

Here is my test file for your reference.