Summarize and remove any rows which has a blank total

jcoke 0
Viewed 35

I have written a DAX code which returns names of individuals with a count of how many customers they own, however what I need to do is only retrieve the names or essentially filter out the names who have a blank total, how would I go about this as I have tried everything

summarizedCAM = 
    SUMMARIZE (
            d_cam,
            d_cam[name],
            "Total", DISTINCTCOUNT(ftm[p_key])
     
   )

Current Output:

enter image description here

dax powerbi
2 Answers

try like this :

Modelling --> New Table

summarizedCAM =
VAR _tbl =
    SUMMARIZE ( d_cam, d_cam[name], "Total", DISTINCTCOUNT ( ftm[p_key] ) )
RETURN
    FILTER ( _tbl, [Total] > 0 )
Umut K0 
summarizedCAM = 
FILTER(
    SUMMARIZE (
            d_cam,
            d_cam[name],
            "Total", DISTINCTCOUNT(ftm[p_key])
    
   )
   ,ISBLANK([Total])=FALSE()
)
userLOTh10
Related