Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi all,
I have the following dax expression (for a calculated table):
TableOne = FILTER(SUMMARIZE('persons', 'persons'[id], 'persons'[name], 'persons'[surname]), 'persons'[age] = 34)
This dax expression works. It returns only rows for persons whose age is 34 years old.
But i would split this dax expression in more than one row (for a better readability).
How can I do?
Thank you for your answers.
Solved! Go to Solution.
Hi @siacc,
Do you mean something like this:
TableOne = FILTER( SUMMARIZE( 'persons', 'persons'[id], 'persons'[name], 'persons'[surname]), 'persons'[age] = 34)
You jus have to do ALT + Enter in the place you want to do the line break you can also add comments in front of the formula to better understandment see example below.
ableOne = FILTER( //Filter table SUMMARIZE( //Summarize table accoding to filter 'persons', 'persons'[id], 'persons'[name], 'persons'[surname]), 'persons'[age] = 34) // age higher then 34
Regards
Mfelix
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsHi @siacc,
Do you mean something like this:
TableOne = FILTER( SUMMARIZE( 'persons', 'persons'[id], 'persons'[name], 'persons'[surname]), 'persons'[age] = 34)
You jus have to do ALT + Enter in the place you want to do the line break you can also add comments in front of the formula to better understandment see example below.
ableOne = FILTER( //Filter table SUMMARIZE( //Summarize table accoding to filter 'persons', 'persons'[id], 'persons'[name], 'persons'[surname]), 'persons'[age] = 34) // age higher then 34
Regards
Mfelix
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsHi @siacc,
Do you mean something like this:
TableOne = FILTER( SUMMARIZE( 'persons', 'persons'[id], 'persons'[name], 'persons'[surname]), 'persons'[age] = 34)
You jus have to do ALT + Enter in the place you want to do the line break you can also add comments in front of the formula to better understandment see example below.
ableOne = FILTER( //Filter table SUMMARIZE( //Summarize table accoding to filter 'persons', 'persons'[id], 'persons'[name], 'persons'[surname]), 'persons'[age] = 34) // age higher then 34
regards
Mfelix
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsUser | Count |
---|---|
101 | |
90 | |
80 | |
71 | |
70 |
User | Count |
---|---|
114 | |
98 | |
97 | |
73 | |
72 |