distinctcount from summarize

[Anonymous]

Hello,
The TableMain at the bottom returns a table with data correctly.

VAR TableMain =
FILTER (
SUMMARIZE (
Table1,
Table1[Field1],
Table2[Field1],
Table1[Field2],
"Count", DISTINCTCOUNT ( Table3[Field2] ),
"Total Sales", [MyMeasure]
),
[Total Sales] > 10
)

Question:
How do I (in a separate measure) do a distincCount of the column Table2[Field1] which is inside the variable TableMain ?

Thank you

[ksubramaniyam41]

I have measure this needs to create new Column because measure is working and getting expected resilts so i need to create column with same resilts Please help some one.

Measure = CALCULATE(DISTINCTCOUNT(TFlex_Usage_Report[USAGE_DT_DAY]),GROUPBY(TFlex_Usage_Report,'TFlex_Usage_Report'[USER_LOGIN_ID],'TFlex_Usage_Report'[Usage_DT_Year],TFlex_Usage_Report[Usage_DT_Month],TFlex_Usage_Report[USAGE_DT_DAY]))

[Nathaniel_C]

Hi @ksubramaniyam41 ,

You would be better off to post your question as a new question.  You will have more people looking at it then.

Thank you,

Nathaniel

[Nathaniel_C]

Hi @Anonymous  and @Greg_Deckler ,

Greg is the master, but does he also have to give a name to the column to have it show up?

Return value

A table with the selected columns for the groupBy_columnName arguments and the summarized columns designed by the name arguments.

Remarks

1. Each column for which you define a name must have a corresponding expression; otherwise, an error is returned. The first argument, name, defines the name of the column in the results. The second argument, expression, defines the calculation performed to obtain the value for each row in that column.

2. groupBy_columnName must be either in table or in a related table to table.

3. Each name must be enclosed in double quotation marks.

4. The function groups a selected set of rows into a set of summary rows by the values of one or more groupBy_columnName columns. One row is returned for each group.

If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos are nice too.
Nathaniel

 

[Greg_Deckler]

Ah, in re-reading this I see that you want it as part of the table, not have the table and then count the numer of distinct values in it. So, I believe that you are going to need to use GROUPBY instead of SUMMARIZE. Because then you can use the CURRENTGROUP functionality of GROUPBY. I *think* that is what @Nathaniel_C  is trying to convey. https://docs.microsoft.com/en-us/dax/groupby-function-dax.

@Anonymous  - Would help if you could post some sample data and expected output. 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

[Greg_Deckler]

Use a SELECTCOLUMNS to grab the column you want to do a distinct count on. Feed that into a DISTINCT and then do a COUNTX on it.