Forum Discussion

Jihwan_Kim's avatar
Jihwan_Kim
Icon for Super User rankSuper User
5 years ago

Hi, deb_power123 

Please check the below picture and the link down below.

 

 

Total Used =
IF (
ISINSCOPE ( 'location'[buildingfloor] ) || ISINSCOPE ( location[Location] ),
SUM ( 'location'[seats used] ) & "|"
& SUM ( 'location'[seats available] ),
BLANK ()
)
 
 

Hi, My name is Jihwan Kim.


If this post helps, then please consider accept it as the solution to help other members find it faster, and give a big thumbs up.


Linkedin: linkedin.com/in/jihwankim1975/

Twitter: twitter.com/Jihwan_JHKIM

deb_power123's avatar
deb_power123
Icon for Helper V rankHelper V
5 years ago

hi Jihwan_Kim 

Thankyou for your reply, your logic does make sense but i am not sure why when i used your formula in the report with more date values and location values, I just got "|"  symobols accross the visual.

 

It looks very weird as i used exactly the same formila you gave above. It is not showing any values and only | symbol . Could you please suggest why it happened and is there anyother way to do this approach ?

 

or if we can make the Occupied value in total say while color so that it mixes with background.Is that possible? 

I am really failing to understand why it is not returning any values when I use your formula.All values suddenly disappeared.

 

Kind regards

Sameer

  • Jihwan_Kim's avatar
    Jihwan_Kim
    Icon for Super User rankSuper User
    5 years ago

    Hi, deb_power123 

    Thank you for your feedback.

    If it is OK with you, please share your sample pbix file, then I can try to look into it to find out the root cause of the issue.

    Thanks.