Forum Discussion
Calculate MIN, MAX, AVERAGE with Count Rows
Dear Power BI community Can you help me with the following. I do not calculate amount but number of cases. I solve that with the DAX formula count rows. But I would like to be able to calculate th...
Hi,
For average create a measure:
Average Countrows = Countrows (<data table>) / Countrows (<calendar dim table>)
For months you will get an average of your countrows per day for each week, for each month, for each year in your calendar dim table depending on what level of drillthrough for a calendar table you are on.
Of course you would have to have a week, month, year calculated columns in your date dim table.
If this is not what you want, could you please provide example of your data table, calendar table as well as expected output for a result.