Forum Discussion

dofrancis3's avatar
dofrancis3
Icon for Resolver I rankResolver I
2 years ago

Mesure and Calendar table

Hi Colleagues! I've created a "Calendar" table, but when I try to create a measure, "Calenda table" doesn't appear. Could you help me to fixe this issue please. In other words, when I call up "Cal...
dofrancis3's avatar
dofrancis3
Icon for Resolver I rankResolver I
2 years ago

Dear Coleagues;

I would like to Summarize "sampled" colomn only if the "date" is not blank 

Be low my mesure

Tot_sampled =
VAR __numberOfInterwd = SUM(LQASrepository[Total sampled),
                                            && LQASrepository[Start date] <> BLANK ())
RETURN
IF(ISBLANK(__numberOfInterwd), "No Data",__numberOfInterwd)
 
Please support
wynhopkins's avatar
wynhopkins
Icon for Most Valuable Professional rankMost Valuable Professional
2 years ago

I don't understand your question sorry