cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Anonymous
Not applicable

Filtering DAX variable

Hi! I have a DAX statement like this :

 

"VAR _road = RST[road]
VAR _section = RST[section]
VAR _dist = RST[distance]

VAR _COMPARISON = CALCULATE(SUM(RST[edgedropoffdepth]); FILTER(RST; RST[distance] = _dist && RST[road] = _road && RST[section] = _section && RST[runname] = 41)) 

 

RETURN
RST[edgedropoffdepth] - _COMPARISON"

 

So basically I have the same road/section/distance and I'd like to compare how the value has changes. Is it somehow possible to but a value for this "VAR _FIRST", if there is no value with desired distances, road, section and runname. So is there a possibility to add somekind of IF statement (or something else).

1 REPLY 1
BrandyG_iTalent
Administrator
Administrator

Hello @Anonymous 

 

Take a look at this article. It contains some great tips for getting your question answered quickly.

 

 https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

 

Thanks for being part of the community!

Helpful resources

Announcements
PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group!

MBAS Attendee Badge

Claim Your Badge & Digital Swag!

Check out how to claim yours today!

secondImage

Are You Ready?

Test your skills now with the Cloud Skills Challenge.

Top Solution Authors