The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
Hello, all,
I am looking at housing data. I want to view the top zip codes by median days on the market in a state. My chart works fine until I introduce the ranking. I have a page filter for california and the chart only returns california zipcodes and their median days on the market. When I add my rankx measure every zip code from the source data is added to the chart non California zip codes return a blank value for median days on and a ranking of 1. Below is the rankx measure I created. Any help would be appreciated, Thanks!
Solved! Go to Solution.
Hi @Anonymous ,
Please find the pbix attached.
Have made some changes to the data model.
Regards,
Harsh Nathani
Hi @Anonymous ,
Can you please share some sample data and expected output to help you better with the issue.
Regards,
Harsh Nathani
Hello, @harshnathani
The data I am using looks similar to the tables below. I have a table on housing data and a geography table. The visualization is just a chart. with the columns Full zip code, median days on market, and the ranking measure. The filters on the visual are Month, Year, and State which is drawing from the Geography table. I am trying to use the ranking measurement as a filter to only display the top ten zipcodes.
NOTE:
I made a mistake when typing my measure in the original post it actually pulls from only one table. Here is what the measure actually is:
------------------------------------------------------------------------------------------------------------------------------------------------
Data Table:
Full zip Code | Median days on market | Month | Year |
90001 | 23 | 03 | 2020 |
90002 | 30 | 03 | 2020 |
------------------------------------------------------------------------------------------------------------------------------------------------
Geography Table:
Full Zip code | State |
90001 | CA |
90002 | CA |
------------------------------------------------------------------------------------------------------------------------------------------------
Expected Output:
Full Zip code | Median days on market | Rank |
90242 | 14 | 1 |
91942 | 15 | 2 |
92116 | 16 | 3 |
------------------------------------------------------------------------------------------------------------------------------------------------
Actual Output:
Full Zip code | Median days on market | Rank |
01001 | 63.5 | 1 |
01002 | 30.5 | 1 |
01007 | 49. | 1 |
Hi @Anonymous ,
Please find the pbix attached.
Have made some changes to the data model.
Regards,
Harsh Nathani
thanks
User | Count |
---|---|
15 | |
8 | |
6 | |
6 | |
6 |
User | Count |
---|---|
23 | |
14 | |
13 | |
8 | |
8 |