none
DAX - Filter only Non empty values RRS feed

  • Question

  • Hi All,

    I am new to DAX and trying to filter only non-empty values. Below is my DAX query and its result:

    EVALUATE (
    SUMMARIZE(FILTER(Dim_Category,Dim_Category[CategoryName]<>""),Dim_Category[CategoryName],"AggreggatedValue",Max(Fact_Items[Value]))
    )

    Dim_Category[CategoryName]    [AggreggatedValue]
    Beauty    290
    Cleaning    160.83
    Entertainment    3598
    Food    805
    Grocery    1150
    Household    11623
    Jewellery    
    Kitchen    
    Medical    95
    Prayer    50
    Vegetables    45
    Washing    109

    I want to exclude Empty results of Jewellery and Kitchen.

    Kindly help me to solve this.

    Thanks in advance!



    Thursday, July 4, 2019 7:06 AM

All replies