Cross-filtering based on two different columns

[Anonymous]

I have a simple report with Total results card.  The default rule for the card is sum of column Message total result - 13 in this case.

But from first table, when a user selects a ConsumerID eg, Global university, Total results card should display 3 (from column Message message result).

If user selects both Global university and City university (holding control key after selecting Global university and selcting City university), the card should display  5   ( 3 + 2).  

Similar performance is expected from selecting an Attoney from second table.  

Message total result should be displayed only when there is no cross-filtrering - no selection from either table. 

I need a DAX for this card. 

Link to PBIX:   https://drive.google.com/file/d/1n00TRLkwPz6IoBMuWYVm1-Y1X1cV0WAH/view?usp=sharing

[selimovd · Accepted solution]

Hey @Anonymous ,

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?

In that case you can easily check if there is a crossfilter happening with the function ISCROSSFILTERED. If that's the case, return BLANK(), otherwise return the measure.

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 👍

Best regards

Denis

Blog: WhatTheFact.bi

Follow me: twitter.com/DenSelimovic