Welcome to deBUG.to Community where you can ask questions and receive answers from Microsoft MVPs and other experts in our community.
1 like 0 dislike
689 views
in Power BI by 4 4 11

I need to Count Rows and I would like to multiply it by 2000 .. this will help me to know what is the right total to be shown to the executives, How can i do that using DAX in Power BI?


1 Answer

2 like 0 dislike
by 4 4 11
 
Best answer

COUNTROWS in DAX

To count the number of rows in a column and then multiply the result by 2000 in Power BI using DAX, you can create a new measure. Here's how you can do it:

  1. In Power BI Desktop, go to the "Model" view.
  2. In the "Fields" pane, right-click on your desired table and choose "New Measure"
  3. In the formula bar, enter the following DAX expression to achieve the desired calculation:

    CountMultiplied = COUNTROWS(YourTableName) * 2000
    
If you don’t ask, the answer is always NO!
...