How do I use variables?

DAX DAX Calculations
1

I apologize for the general question. I find i can’t use variables predictably, especially when I try to use the HASONEFILTER pattern to correct totals. I get the right results when I use the entire formula, but if I try to use variables, the results are incorrect.

Can anyone point me to resources that can illustrate how variables actually work?

1 Like
2
3
1 Like
4

@tigerec Always share complete information when you ask a question. I hope you understand if I ask you the same question you will have a hard time solving it. You can start by sharing DAX code and PBIX file that replicates the issue.

5

Thank you @DavieJoe your reply for SQLBI article is useful.

1 Like
6

Glad to hear it @tigerec

Variables are really powerful, can make your code clearer and faster.

1 Like