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 , Could you please help me with this one. TIA

Ashish_Mathur's avatar
Ashish_Mathur
Super User
7 years ago

Hi,

 

Share the link from where i can download your PBI file.  You may share a small dataset.  More importantly, share the exact result you are expecting.

  • 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. 

    • Ashish_Mathur's avatar
      Ashish_Mathur
      Super User
      7 years ago

      Hi,

       

      Try this calculated column formula

       

      =if(LOOKUPVALUE(price_check[Net Rent/ sqm],price_check[einzug],CALCULATE(MAX(price_check[einzug]),FILTER(price_check,price_check[Apartment Index]=EARLIER(price_check[Apartment Index])&&price_check[einzug]<EARLIER(price_check[einzug]))),price_check[Apartment Index],price_check[Apartment Index])>[Net Rent/ sqm],"Lower",if(LOOKUPVALUE(price_check[Net Rent/ sqm],price_check[einzug],CALCULATE(MAX(price_check[einzug]),FILTER(price_check,price_check[Apartment Index]=EARLIER(price_check[Apartment Index])&&price_check[einzug]<EARLIER(price_check[einzug]))),price_check[Apartment Index],price_check[Apartment Index])<[Net Rent/ sqm],"higher","Same"))

       

      Hope this helps.

      • Anonymous's avatar
        Anonymous
        Not applicable
        7 years ago

        Hi Ashish_Mathur, Thank you for the formula. But when I tried this, I'm getting "A table of multiple values was supplied where a single value was expected" error. What could be the reaosn for this ?