Forum Discussion
Group by issues
I need Any one help on this Dax query
Amount = CALCULATE(SUM(Demo[total]), MONTH(Demo[startdate]) >=MONTH(TODAY()),MONTH(TODAY()) <=MONTH(Demo[enddate]))
this dax query returns the total of all categories
Amount = 100
but i want to display catgories wise with that measures.. for example,
Books 20
Benches 30
pens 10
bags 40
i tried to groupby that dax queries that not works... Kindly let me know if any solutions is possible..
Advance thanks to all,
- 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.
4 Replies
- Anonymous - So generally you would just put Category into a visual (like a Table visualization) as well as your measure.
hi Greg_Deckler ,
Thanks for your reply, but I need to group by that in measure ...not using the visuals is it possible?
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.
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