Forum Discussion

Cyriackpazhe's avatar
Cyriackpazhe
Helper III
1 year ago
Solved

expanded table

Calculate ( countrows( Regions), Sales)) . Here Regions is part of the expanded table of Sales. Can someone explain how the table "Sales" as calculate argument is used to evaluate the expression. The...
  • Anonymous's avatar
    Anonymous
    1 year ago

    Hi ,

    Based on the information, the countrows(Regions) function counts the number of rows in the Regions table. Because CALCULATE adjusts the filter context using the Sales table, only those Regions that are linked to the current set of rows in Sales are considered.

    Using the DAX formula.

     

    You can view the following documents to learn more information.

    CALCULATE function (DAX) - DAX | Microsoft Learn

    COUNTROWS function (DAX) - DAX | Microsoft Learn

     

    Best Regards,

    Wisdom Wu

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Anonymous's avatar
Anonymous
Not applicable
1 year ago

Hi ,

Based on the information, the countrows(Regions) function counts the number of rows in the Regions table. Because CALCULATE adjusts the filter context using the Sales table, only those Regions that are linked to the current set of rows in Sales are considered.

Using the DAX formula.

 

You can view the following documents to learn more information.

CALCULATE function (DAX) - DAX | Microsoft Learn

COUNTROWS function (DAX) - DAX | Microsoft Learn

 

Best Regards,

Wisdom Wu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.