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.
can someone help me to filter the data without having a table relationship?
I have data where I shouldn't create a relationship to arrive at the cross-selling numbers. but I need the Total value should be appearing for the intersecting Count.
Currently, the total on the tooltip is showing the Total value of the Column.
I have used the below DAX- which did not work.
Basically the tooltip should show the below value.
Help would be much appreciated.
Regards,
Ranjan
I'm not clear about "11 count" you refered.
When i change measure, the tooltip show different result.
Measure =
CALCULATE (
[TVPS],
FILTER (
'S&P',
FIND ( 'S&P'[SubServiceLineGroupingDesc], MAX ( 'Comparision SSL'[SSL] ), 1, 0 ) > 0
)
)
is this what you want?
Best Regards
Maggie
Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
I didn't try it in your report, but you can pass filters without using a relatonship with the TREATAS() function. Here is an example using your measure
If this works for you, please mark it as the solution. Kudos are appreciated too. Please let me know if not.
Regards,
Pat
To learn more about Power BI, follow me on Twitter or subscribe on YouTube.
Hi @mahoneypat sorry, My bad luck. it doesn't give any value(Just (Blank).
Basically I have created the table using the below formula.
Why the matrix is filtered as below:
Is any filter selected?
Best Regards
Maggie
Hi @v-juanli-msft sorry that is total Value i waas expecting for the "11" Count in my table tooltip(14,471,559 ).
Its basically the intersecting value for Both Audit and Adv solution.
I have worked out this in Excel by taking the combination of UDN(ID) count with total value.
But currently the tooltip i am getting the total value of Audit/Adv Solution i.e
Adv Solutions Audit
21,511,194 51,910,380
Kindly let me know if you need more clarification on this.
Regards,
Ranjan
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 |
---|---|
101 | |
50 | |
19 | |
12 | |
11 |