Group by issues

[Anonymous]

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,

[Greg_Deckler · Accepted solution]

@Anonymous - So generally you would just put Category into a visual (like a Table visualization) as well as your measure.

[amitchandak · Accepted solution]

@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

[amitchandak · Accepted solution]

@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

[Greg_Deckler · Accepted solution]

@Anonymous - So generally you would just put Category into a visual (like a Table visualization) as well as your measure.

[Anonymous]

hi @Greg_Deckler ,

  Thanks for your reply, but I need to group by that in measure ...not using the visuals is it possible?

[Greg_Deckler · Accepted solution]

@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.