Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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?
Regards,
Ranjan
@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
access to your file is denied
anyway, try ALL()
Measure = CALCULATE([TVPS],
FILTER(ALL('S&P'),
'S&P'[SubServiceLineGroupingDesc]in VALUES('Comparision SSL'[SSL])))
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.
Regards,
Ranjan
Sorry @RanjanThammaiah
I do not understand what exactly is going wrong.
I see another tooltip digits
sorry, even the other one is not working. there I have added the total value field instead of the Measure value.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
99 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
102 | |
87 | |
64 |