- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Related Table grouping sum
I'm using some related tables to create a report, the left most table has the values sold, and the right most table has the information which I want to group by. Power bi isn't able to create the sum or the count by itself and don't give me the option to use the calculate function, Any one knows what is happening?
The DAX CALCULATE function is not avaiable when I'm trying to create a calculated column, only avaiable when creating a measure, is it related with my problem?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
I assume you are using a DirectQuery mode and that is why you cannot use the CALCULATE function in a calculated column.
Anyway, the default measure does not return the expected results because of the propagation of filter: TCOM_PEDSAI filters TCOM_ITEDPS, which filters TCOM_PROSER.
You will have to write the relevant measure. The measure should look something like this:
= CALCULATE( YourExpression , SUMMARIZE( TCOM_PROSER , TCOM_PEDSAI[PEDS_COD] ) )
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi, thanks for the help. But Summarize function don't appear for me either. any ohter idea what this could be?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
I forgot to mention I activated the following options:
File > Options and Settings > Options > DirectQuery > Allo unrestricted measures in DirectQuery mode
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
@LaurentCouartouI believe that only makes those restricted functions available for measures, and @vitinho is trying to use them in columns. I don't think that option will help here.
Did I answer your question? Mark my post as a solution!
Proud to be a Super User!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
You are right, that is why I suggested writing a measure in my previous post.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
This has been brought up in at least two threads now. Are you using import, or direct query? Some functions are limited in direct query mode.
Did I answer your question? Mark my post as a solution!
Proud to be a Super User!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Direct Query
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
https://msdn.microsoft.com/en-us/library/mt723603.aspx
Did I answer your question? Mark my post as a solution!
Proud to be a Super User!

Helpful resources
Subject | Author | Posted | |
---|---|---|---|
07-24-2024 06:40 PM | |||
05-06-2024 02:42 AM | |||
01-26-2024 05:16 AM | |||
06-20-2024 07:27 AM | |||
10-22-2021 07:46 AM |
User | Count |
---|---|
141 | |
112 | |
83 | |
63 | |
47 |