DAX Measure for calculating average from a table in power bi ........

[Anonymous]

Hi Everybody,

Any help appreciated, pretty new at this.   I have created a table in Power BI that comes from 3 different tables in the dataset.  The table contains 5 columns.   

• I need to now create 3 Cards. 

           1 Card that will give me total rows in the Power BI table

           1 Card that shows me a distinct count of 1 of the columns in the Power BI table

           1 Card that shows me the average (total rows divided by distinct count) in the Power BI table

How would I go about getting the correct numbers for the total rows, distinct count, and avg.  from the rows that only show in the Power BI table ?  (Not the data tables)

(Using Distinctcount and countrows on the actual table gives me the numbers from the actual tables in the dataset and not the Power BI table.....also ,  I have a slicer involved so the calcs need to be dynamic)

Thank you for any help

[amitchandak]

@Anonymous , Avg of Distinct. a new measure

Averagex(Values(Table[Value]), [Value])

or

divide(distinctcount(Table[value]), countrows(distinct(Table[value])) )