Forum Discussion
Post PatronExpression/ measures based on the give data Ask
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
Community ChampionYes 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