DEFINE MEASURE - DAX Guide

The DEFINE MEASURE statement introduces a measure definition in a query (also known as query measure).

This video is part of DAX Guide, the online guide to all the DAX functions, with links to related content and compatibility matrix with all the versions of Power BI, Azure Analysis Services (AAS), SQL Server Analysis Services (SSAS), SQL Server Data Tools (SSDT), and Power Pivot for Excel.


#dax #powerbi #ssas #tabular #analysisservices #powerpivot

[narendrababu]

There will be some columns where I can directly use the column reference in values section or in a measure where don't want any aggregation. I just want to pick the value from from the the same row depending on a selection. For example

example: if(selectedvalue(col1)="me", col2, blank())

I want to achieve the above example shown but in true case we cannot use column reference directly, we need to use aggregation or a measure. I don't want to use aggregation or measure, I just need to get the result just from the selection. So, how can I achieve this. Please do a video on this topic. It's a request.

[mominsaifuddin]

can you make a videos on how to write Dax query in dax studio

[asutoshkumar]

How can we more about this? Any documentation? Can we use VAR instead of this?