When relationship is intactive, result is as below :
While the same code with active relationship provides the right result as below :
How should I rewrite the code to be able to inactivate relation and use "userelationship()" fuction in measure instrad.
Solved! Go to Solution.
@tanat_inc , Try a measure like
Campus Visit =
VAR _table = SUMMARIZE('f_visit_info','f_visit_info'[visit_date],"distinctcount",calculate(DISTINCTCOUNTNOBLANK('f_visit_info'[hn]),
USERELATIONSHIP('d_date_table'[Date],f_visit_info[visit_date])))
RETURN CALCULATE(
SUMX(_table,[distinctcount])
)
@tanat_inc , Try a measure like
Campus Visit =
VAR _table = SUMMARIZE('f_visit_info','f_visit_info'[visit_date],"distinctcount",calculate(DISTINCTCOUNTNOBLANK('f_visit_info'[hn]),
USERELATIONSHIP('d_date_table'[Date],f_visit_info[visit_date])))
RETURN CALCULATE(
SUMX(_table,[distinctcount])
)
It's work !!!
You solved 3 of my issues already in this month.
That's really save my day.
Thank you very much 🙂 🙂
Thanks friend, this should be a useful alternative work around.
Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!
User | Count |
---|---|
118 | |
74 | |
65 | |
51 | |
49 |
User | Count |
---|---|
184 | |
104 | |
82 | |
79 | |
78 |