Forum Discussion
Post PatronExpression/ measures based on the give data Ask
Community ChampionWell, I can tell you that your code is not correct. 🙂 Count is a valid DAX function but not Aggr or NODISTINCT, no idea where those came from. Having some difficulty understanding your requiremens.
You could do number 7 like AVERAGEX(ALL('Table'),[Price]).
I think you should refer to this: https://docs.microsoft.com/en-us/dax/dax-function-reference
Post PatronGreg_Deckler have you check the document data ? there is several fields in that document .. kindly check . mostly i think question depend on Host ID and price.. and also property type column / field is also in data..
kindly check data once .. you better understand it
and i just want dax functions according to questions.. i already give the data
- Greg_Deckler
Yes Bakhtawar I have the Excel file open and I am looking at it, or I was just prior to responding to this post. The problem is I am not understanding things like:
1. Percentage and number of the host with the multi-listing from the total host.
OK, number of the host, so are you saying the number of distinct hosts or the rows for each host? multi=listing from the total host. I have no idea what that means. Are you saying that you want the number of rows of each host divided by the total number of rows for all hosts?
- Bakhtawar
multi listing means if host id has duplicate records
if Host ID has duplicate records then total count of that host ie.. if 5 ID has 10 records then
host id count
5 10
6 20
and single listing means if Host ID did not repeat