Count and Multiply In Power BI

Question

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?

Answer 1

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