Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
anamika
Frequent Visitor

Dax Query

Hi,

I am faceing one issue with dax query which is written in DAX Query application. 

dax query is -
EVALUATE
ADDCOLUMNS (
    SUMMARIZECOLUMNS (
        'Dim MWBEProgram'[MWBEProgramName],
        FILTER ( 'Fact Contract', 'Fact Contract'[MWBEProgramID] <> BLANK () ),
       
        FILTER ( 'Fact Contract', 'Fact Contract'[ContractNumber] = "1234" )
    )
    ,
    "STATUS", IF ( 'Dim MWBEProgram'[MWBEProgramName] = "Non M/WBE", "NON M/WBE", "M/WBE" )
)

So, getting output like this:

Output.PNG

 

Is it possible to get only 'STATUS' Column?

5 REPLIES 5
d_gosbell
Super User
Super User

Can you clarify what your issue is? I can't see any output in this post, is there an error or unexpected data in the results?

 

My output is :

 

Output.PNG
Is it possible to get only "STATUS"Column?


@anamika wrote:

Is it possible to get only "STATUS"Column?


You can, the question does not make a lot of sense to me as I can't see how this column will make sense on its own, but you could use SELECTCOLUMNS to just return the STATUS column

 

eg

 

EVALUATE
SELECTCOLUMNS(
ADDCOLUMNS
 (
    SUMMARIZECOLUMNS (
        'Dim MWBEProgram'[MWBEProgramName],
        FILTER ( 'Fact Contract''Fact Contract'[MWBEProgramID] <> BLANK () ),
       
        FILTER ( 'Fact Contract''Fact Contract'[ContractNumber] = "1234" )
    )
    ,
    "STATUS"IF ( 'Dim MWBEProgram'[MWBEProgramName] = "Non M/WBE""NON M/WBE""M/WBE" )
)
"STATUS", [Status]
)

Getting error with the given query.


@anamika wrote:

Getting error with the given query.


What is the error message?

 

I can't run your exact query as I don't have access to your model, but I've run similar queries with this pattern and they work fine.

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.