How to count the number of groups (but not actually doing an aggregation on an additional column)?

[Anonymous]

Hi,

I have a table visual that looks like the below (it's been filtered in the report using a.rundate = 2017 & 2018):
a.srcmoduleid          a.rundate          Column3          Column4          Column5
English                       13/04/2018        5                       Yes                     3
English                       13/04/2018        1                       No                     3
English                       13/04/2018        3                       No                     14
English                       12/04/2018        2                       No                     2
English                       12/04/2018        2                       Yes                     13

English                       11/02/2017        1                       Yes                     1
Maths                         20/02/2018        44                    Yes                      22

So taking the above table visual contents (i.e. the filtered dataset in play at this point), I would like to just count the number of groups based on a.srcmoduleid and a.rundate. The rest of the columns are not required (I've just put them in the above so you know there are additonal columns). The value I'm looking for from the above is English = 3, and Maths = 1. I will look to place these values in a bar-chart.

I have produced the below bit of code thinkning it'll be the answer but it doesn't return what I'm looking for:

tbl_CountLoadsByGroupingOn_a.sourceid_And_a.rundate
          = SUMMARIZE(
                    Fact_Dataloads,
                    Fact_Dataloads[a.srcmoduleid],
                    Fact_Dataloads[a.rundate],
                   "TablesLoadedPera.rundateAndModuleID", DISTINCTCOUNT( Fact_Dataloads[a.rundate] )
                                  )
I'm thinking as the filter a.rundate is set in the background then those same fitlers will be applied to the SUMMARIZE function above.

The actual result I get from the above is:
a.srcmoduleid          a.rundate          TablesLoadedPera.rundateAndModuleID

English                      13/04/2018         25
English                      12/04/2018         25

English                      11/02/2017         25
Maths                        20/02/2018        16

It must be counting on a more granular basis than what I have scope for in my SUMMARIZE function. I was expecting 1 for each of the rows under the TablesLoadedPera.rundateAndModuleID column.
So I then set the TablesLoadedPera.rundateAndModuleID property in the Power bI table visual from 'Count' to 'CountDistinct' and it return the below:

a.srcmoduleid          a.rundate          TablesLoadedPera.rundateAndModuleID

English                      13/04/2018         1
English                      12/04/2018         1

English                      11/02/2017         1
Maths                        20/02/2018         1

I'm now thinking it's showing 1 under the TablesLoadedPera.rundateAndModuleID column as I have it to the granular level of a.rundate. So I remove a.rundate from the table visual and I can the below:

a.srcmoduleid          TablesLoadedPera.rundateAndModuleID

English                       1
English                       1

English                       1
Maths                         1

My end goal is to see the below:

a.srcmoduleid          TablesLoadedPera.rundateAndModuleID

English                       3
Maths                         1

I hop you understand what I'm trying to acheive. Please help?
Thanks in advance.

[Anonymous · Accepted solution]

Please don't respond (look into my question) guys as I've managed to resolve it myself. I guess I just needed to step away from it to clear my eyes.

In case anyone is interested, the fix was a simple DAX statement:
NumberOfLoadsByModuleIDandRundate =
CALCULATE(
DISTINCTCOUNT( Fact_Dataloads[a.rundate] ),
GROUPBY( Fact_Dataloads,
Fact_Dataloads[a.srcmoduleid],
Fact_Dataloads[a.rundate]
)
)

Quite simple, but it always is when you know how  😉