Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply

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

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
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.