Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Need help

Hello All,   I need to find something from my dataset which seems to be complicated for me, if anyone could help.     As you can see in the data, once a tenant moves out the net rent might...
Need Help
Show and Tell
Tips and Tricks
Anonymous's avatar
Anonymous
Not applicable
7 years ago

Hi Ashish_Mathur

 

Here is the link you can have the PB file.

 

 

Result which I am expecting.

 

 

 

 

v-chuncz-msft's avatar
v-chuncz-msft
Community Support
7 years ago

Anonymous,

 

Drag measure below to visual level filter and set Show items when the value is greater than 1.

Measure =
CALCULATE (
    DISTINCTCOUNT ( price_check[Net Rent/ sqm] ),
    ALLEXCEPT ( price_check, price_check[Apartment Index] )
)
  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    Hi v-chuncz-msft Sam, I need something else, not what you have suggested.