Forum Discussion
summary view on measure column
Anonymous
It can be solved in one of 3 ways or, instead of a measure, it can be calculated in the calculated column.
You can also use field parameters
Or create a summarized table with your measure.For a more detailed solution
Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
https://community.powerbi.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-...
Please show the expected outcome based on the sample data you provided.
https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523
Super UserHi Anonymous
I wasn't quite sure what was meant by "measure column."
However, according to your data structure, you must display it as a matrix like on the picture:
It is important to note that to have months appear chronologically, you must add a numeric column for each month and sort the names of the months by their numeric value
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly.
Thank you! Ritaf1983
I am not able to add the NLH to Rows in the visualization. This is a derived/calculated column.
Anyother possible way to resolve?
- Ritaf1983
Anonymous
It can be solved in one of 3 ways or, instead of a measure, it can be calculated in the calculated column.
You can also use field parameters
Or create a summarized table with your measure.For a more detailed solution
Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
https://community.powerbi.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-...
Please show the expected outcome based on the sample data you provided.
https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523