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] )
)