Showing results for 
Search instead for 
Did you mean: 
Helper V
Helper V

Is there any possibility to filter the data without relationship

Hi All,


can someone help me to filter the data without having a table relationship?

I can create a relationship and get the numbers right whereas I am doing basket analysis where I shouldn't relate to that table to arrive the number.


In the below table I am unable to get the right number on the tooltip. where it should be the combination of 29 counts. but I am getting the total number of Audit and Adv solution. (Rows  from SSL table and Columns  from Comparison SSL)


Let me know if there any alternatives?


Cross selling.png




Super User
Super User

@RanjanThammaiah , Yes you have force a filter in a Measure

calculate([Measure], filter('S&P','S&P'[SSL] in selectedvalues('SSL'[SSL])))


calculate([Measure], filter('S&P','S&P'[SSL] in values('SSL'[SSL])))


I have not used complete table names. Please use correct table and column name

Did I answer your question? Mark my post as a solution! Appreciate your Kudos!! !!
Dashboard of My Blogs !! Connect on Linkedin
Want To Learn Power BI
Learn Power BI Beginners !! Advance Power BI Concepts !! Power BI For Tableau User !! Learn Power BI in Hindi !!
Proud to be a Super User!

Hi @amitchandak 


i have used the DAX as below. but the values are blank now.


Here is the link for sample report Sample Report 


Measure = CALCULATE([TVPS],FILTER('S&P','S&P'[SubServiceLineGroupingDesc]in VALUES('Comparision SSL'[SSL])))

Hi @RanjanThammaiah 

access to your file is denied

anyway, try ALL()

'S&P'[SubServiceLineGroupingDesc]in VALUES('Comparision SSL'[SSL])))

do not hesitate to give a kudo to useful posts and mark solutions as solution

thanks for the reply @az38 .


Unfortunately, it started giving one SSL total.


Here is the new link for the  Sample Report

Let me know still the link doesn't work for you(it's in the Dropbox)


The highlighted value I was looking for the 11 Counts.


Cross selling.png








Sorry @RanjanThammaiah 

I do not understand what exactly is going wrong.

I see another tooltip digits


do not hesitate to give a kudo to useful posts and mark solutions as solution

sorry, even the other one is not working. there I have added the total value field instead of the Measure value.

Helpful resources

Power BI December 2021 Update_carousel 768x460.jpg

Check it Out!

Click here to read more about the December 2021 Updates!

Jan 2022 Dev Camp 768x460 copy.png

Power BI Dev Camp- January 27th, 2022

Mark your calendars and join us for our next Power BI Dev Camp!

UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Top Solution Authors
Top Kudoed Authors