Forum Discussion
Grouping continuous measure into groups in DirectQuery
Hi Anonymous
I'll test it later under DQ mode, before that, do you have dimension table containing groups?
If not, you need to use switch() to get the expected outcome.
-
Update:
create the measure below
group = var _value=[Measure] return SWITCH(TRUE(), _value>0&&_value<=0.25,"0 % - 25 %", _value>0.25 && _value<=0.5,"25 % - 50 %")Best Regards,
Community Support Team _Tang
If this post helps, please consider Accept it as the solution to help the other members find it more quickly.
It says it cannot find the table 'Group' when I make the measure. The 'Sheet2$' is not connected to 'Group' - I guess that is the problem? I cannot connect them as the group in the 'Group' is a calculated measure.
Hi Anonymous
Did you create the table Group? If not, you need to create it first. 'Sheet2$' does not need to connect to 'Group'
Best Regards,
Community Support Team _Tang
If this post helps, please consider Accept it as the solution to help the other members find it more quickly.
Hello,
Yes I did:
Where:
- Procentgruppe = Group
- 4_FEATURIZ_SOMMERHUSUDLEJNINGER = Sheet2$