cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
RanjanThammaiah
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

 

Regards,

Ranjan

6 REPLIES 6
amitchandak
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])))

or

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

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

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

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

 

Regards,

Ranjan

 

 

 

 

Sorry @RanjanThammaiah 

I do not understand what exactly is going wrong.

I see another tooltip digits

Безымянный.png


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

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

Helpful resources

Announcements
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