Forum Discussion

hrafnkel11's avatar
hrafnkel11
Helper I
2 years ago

Alternatives to ADDCOLUMNS for DirectQuery

Hi - I'm in the process of splitting apart one Power BI report into two. Semantic Model 1 will house historical Contact/Account data with associated measures and Report B will house test score data t...
Need Help
Ahmedx's avatar
Ahmedx
Super User
2 years ago

I'm not sure but try this

# Certified = 
SUMX(  
        SUMMARIZE(
            'Contact','Contact'[Role],
             "Certified",[Certified] 
             ), 
        [Certified]
		)

 

  • hrafnkel11's avatar
    hrafnkel11
    Helper I
    2 years ago

    Thanks! I tried this, as well as a couple other approaches. Power BI seems to just spin. Seems to be unable to produce the calculation. My guess is maybe it doesn't like the SUMX being used against the live connected data source?