Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
1 year ago
Solved

Specific Filter

Hello Community, I'm new to Power BI and I have a question - I wish to filter out null values BUT ONLY for those product_ID s where there is no other string value than null. In other words, if a c...
Need Help
  • SamWiseOwl's avatar
    SamWiseOwl
    1 year ago

    Hi Anonymous 
    Where were you thinking of creating this?

    As a calculated column you could do something like this:

    Test value = If(
        BLANK() in CALCULATETABLE(Values(Sales[PaymentDate])) --Are there blanks in the other list
         && CALCULATE(DISTINCTCOUNT(Sales[PaymentDate])) = 1  --And there is only one variant in the data
         ,"Only Nulls", "Mixed")
     
    Here for each shopping centre it is joined to a Sales table.
    Each centre has multiple transactions.
    If the Centre only has one transaction and its blank then return Only Nulls.
     
    I could then use this as a filter on the visual.

     

Anonymous's avatar
Anonymous
Not applicable
1 year ago

Hello SamWiseOwl - brilliant, thank you so much!


  • v-karpurapud's avatar
    v-karpurapud
    Community Support
    1 year ago

    Hi Anonymous 

    we wanted to kindly follow up to check if the solution provided by our community member  SamWiseOwl  helps you? If it is worked for you please Accept it as Solution or let us know if you need any further assistance here? 

    Your feedback is important to us, Looking forward to your response.

     

    Thank You.