Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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 Regions[Regions] column part of the expanded "sales" table.
Solved! Go to Solution.
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.
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.
@Cyriackpazhe in Power BI with Star schema model, Sales table is fact table and via relationships other tables are expaned table of Sales, some of details on link.
Proud to be a Super User!
User | Count |
---|---|
25 | |
12 | |
8 | |
6 | |
6 |
User | Count |
---|---|
26 | |
12 | |
11 | |
9 | |
6 |