Forum Discussion
Group by issues
- Anonymous - So generally you would just put Category into a visual (like a Table visualization) as well as your measure.
Anonymous , Are you running this query in dax studio ?
If you doing that is power bi, then you need axis/row/field to group data on the visual
Anonymous - Yes, but it is difficult to provide an exact solution as I do not understand your source data or what exactly you are trying to accomplish. The general format is:
Measure =
VAR __Table =
GROUPBY(
'Table',
[Grouping Column],
"Aggregation",SUMX(CURRENTGROUP(),[Value Column])
)
RETURN
<some operation over __Table>
If that is not specific enough, please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490
The most important parts are:
1. Sample data as text, use the table tool in the editing bar
2. Expected output from sample data
3. Explanation in words of how to get from 1. to 2.
Community Championhi Greg_Deckler ,
Thanks for your reply, but I need to group by that in measure ...not using the visuals is it possible?
- Greg_Deckler
Anonymous - Yes, but it is difficult to provide an exact solution as I do not understand your source data or what exactly you are trying to accomplish. The general format is:
Measure =
VAR __Table =
GROUPBY(
'Table',
[Grouping Column],
"Aggregation",SUMX(CURRENTGROUP(),[Value Column])
)
RETURN
<some operation over __Table>
If that is not specific enough, please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490
The most important parts are:
1. Sample data as text, use the table tool in the editing bar
2. Expected output from sample data
3. Explanation in words of how to get from 1. to 2.