The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
Solved! Go to Solution.
Hi @duncfair ,
I looked at your dax and according to your description, your DAX returns empty.
For this DAX, it is important to be clear whether you are creating measures or creating new columns. If it is a measure, then whether the "[SelectedKPI_Month]" in your VAR Mth = [SelectedKPI_Month] is another measure, you can't use the column name to get the data here.
For you to return null, my advice to you is that when you define a variable every time, you use return to verify the value of the variable to see if it is caused by a variable calculation error.
Best Regards,
Neeko Tang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @duncfair ,
I looked at your dax and according to your description, your DAX returns empty.
For this DAX, it is important to be clear whether you are creating measures or creating new columns. If it is a measure, then whether the "[SelectedKPI_Month]" in your VAR Mth = [SelectedKPI_Month] is another measure, you can't use the column name to get the data here.
For you to return null, my advice to you is that when you define a variable every time, you use return to verify the value of the variable to see if it is caused by a variable calculation error.
Best Regards,
Neeko Tang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Thanks. I will dig in further, but the variables in question are the selected slicer values on the page.
User | Count |
---|---|
26 | |
10 | |
8 | |
6 | |
6 |
User | Count |
---|---|
32 | |
14 | |
11 | |
10 | |
9 |