what the necessary syntax is

[Nihed]

Hi,

In my model I have a table "MakeScenario" which contains the following columns:
Make type, Make Label, MakeCode I wanted to make a cross table in my report that contains a single "Make" field  then I made a  What if filter(1,2, 3) that I created in power BI which allows me to filter each time what I want to see in the table either Make Type or Make Label or Make Code
What syntax DAX can I use it please ?

Thank you

[VahidDM]

@Nihed 

Can you add a asmple of your data and result table in a table format?

How to Get Your Question Answered Quickly

Appreciate your Kudos!!