Forum Discussion
Help with DAX Variables
I have 3 formulas Total = (CALCULATE('Sales'[x], 'Customers'[Markets]="All of US")) CustomSales = (CALCULATE(SWITCH( SELECTEDVALUE('Customers'[Total US Markets]), "Retailer 4", CALCULATE(...
These are all measures, each specific variable is a measure already and that second part with the sumx is a measure but I'm trying to combine it all into one thing with one chunk of dax text.
Hi, Anonymous
You can try to split the measure and placing each of the 3 measures in the visual to see if an error is reported.
In addition, would you like to share your .pbix file (remove sensitive data) so that we can help you better, or provide the corresponding sample data and table relationships in the form of a table?
Best Regards,
Aniya Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly