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?
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] ) )
I forgot to mention I activated the following options:
File > Options and Settings > Options > DirectQuery > Allo unrestricted measures in DirectQuery mode
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.
Power BI release plans for 2023 release wave 1 describes all new features releasing from April 2023 through September 2023.
Make sure you register today for the Power BI Summit 2023. Don't miss all of the great sessions and speakers!
We had a great 2022 with a ton of feature releases to help you drive a data culture.