Forum Discussion

hrafnkel11's avatar
hrafnkel11
Icon for Helper I rankHelper 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
Icon for Super User rankSuper User
2 years ago

I'm not sure but try this

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

 

hrafnkel11's avatar
hrafnkel11
Icon for Helper I rankHelper 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?