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?
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:
Model
Fields
New Measure
In the formula bar, enter the following DAX expression to achieve the desired calculation:
CountMultiplied = COUNTROWS(YourTableName) * 2000
1k questions
671 answers
452 comments
193k users
Related Activities
Categories
Most popular tags