Cross-filtering based on two different columns

Question

&nbsp;I have a simple report with Total results card.&nbsp; The default rule for the card is sum of column Message total result - 13 in this case.&nbsp;But from first table, when a user selects a ConsumerID eg, Global university,&nbsp;Total results card should display 3 (from column Message message result).&nbsp;If user selects both Global university and City university (holding control key after selecting Global university and selcting City university), the card should display&nbsp; 5&nbsp; &nbsp;( 3 + 2).&nbsp;&nbsp;&nbsp;Similar performance is expected from selecting an Attoney from second table.&nbsp;&nbsp;&nbsp;Message total result should be displayed only when there is no cross-filtrering - no selection from either table.&nbsp;&nbsp;I need a DAX for this card.&nbsp;&nbsp;Link to PBIX:&nbsp; &nbsp;https://drive.google.com/file/d/1n00TRLkwPz6IoBMuWYVm1-Y1X1cV0WAH/view?usp=sharing&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;

selimovd · Accepted Answer

Hey&nbsp;Anonymous&nbsp;,&nbsp;I'm not sure if fully understand what you want. The explanation was not very clear for me.I understood that you want only a value in the measure "Message TOTAL RESULT" when the table is not crossfiltered and no result when it's crossfiltered. Is that right?&nbsp;In that case you can easily check if there is a crossfilter happening with the function&nbsp;ISCROSSFILTERED. If that's the case, return BLANK(), otherwise return the measure.&nbsp;If you need any help please let me know.If I answered your question I would be happy if you could mark my post as a solution ✔️ and give it a thumbs up 👍&nbsp;Best regardsDenis&nbsp;Blog: WhatTheFact.biFollow me: twitter.com/DenSelimovic

Forum Discussion

Cross-filtering based on two different columns

1 Reply

Related content

Cross filtering problems

cross filtering

bi-directional cross filter

advanced cross filtering with deneb and vega - brushed area disappearing when doing cross filter

Filter cross different tables