topic Re: Columns not used in a table or visualization in DAX Commands and Tips

Columns not used in a table or visualization

Anonymous — Thu, 28 Sep 2023 08:26:14 GMT

Hi,

I am trying to create a measure to calcualte something based on what columns are used in a visualization. for example if measure A and B are used in a table as columns. Isfiltered() seems fine to use if I want to check if something is being used but how to check if other measures are not used, specifically all the rest? So, as an example I want to write an IF so that if measure A is used in the table to calculate formula A, If the measure B is used to calculate formula B, If A and B are used to calculate Formula A and If anything else is used in the table, even if Measure A or B is used, to return 0 or null.

Of course there are some filters on the page too which should not affect the results.

(Additional information) :

This is what I want to make it work

Measure A	Measure B	Other Measures	Result
True	False	False	Formula A
False	True	False	Formula B
True	True	False	Formula A
Fale	False	False	Blank
Fale	False	True	Blank
True	False	True	Blank
False	True	True	Blank
True	True	True	Blank

Thank you in advance

Re: Columns not used in a table or visualization

Anonymous — Thu, 28 Sep 2023 02:47:55 GMT

Hi Anonymous ,

Please have a try.

Dynamic Measure = IF ( ISINSCOPE ( Table1[Measure A] ), [Formula A], IF ( ISINSCOPE ( Table1[Measure B] ), [Formula B], BLANK () ) )

If I have misunderstood your meaning , please provide more details with your desired output and pbix file without privacy information (or some sample data) .

Best Regards
Community Support Team _ Rongtie

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Re: Columns not used in a table or visualization

Anonymous — Thu, 28 Sep 2023 08:23:55 GMT

Well you are on track but you made me realize I have to add more detail to the question. I will add them in the main text and will explain here now too: The main problem is that If Measure A is used as a column and then another measure is also added as a column I want it to return blank. So the result is like this:

Measure A	Measure B	Other Measures	Result
True	False	False	Formula A
False	True	False	Formula B
True	True	False	Formula A
Fale	False	False	Blank
Fale	False	True	Blank
True	False	True	Blank
False	True	True	Blank
True	True	True	Blank