summary view on measure column

[Anonymous]

Hello,
I have a table (Tab1) with data as mentioned below. Column NLH is a measure column. 

I want to display a visulaization something like below - 

Could you please help to resolve this?
Thanks! in Advance. 

[Dhairya]

You have to create following new measure:
Count =
CALCULATE (
COUNT ( Tab1[NLH(Measure)] ),
ALLEXCEPT ( Tab1, Tab1[NLH(Measure)], Tab1[Month] )
)

Then use matrix visuals to plot your fields:
Rows: NLH(Measure)
Columns: Month
Values: Count (the new measure which we created)

Instead of using NLH as measure you have to Create NLH as a calculated Columns so that You can use it as row in matrix visual.

Please mark my solution as accepted if it helped you!

[Ritaf1983]

Hi @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

Link to a sample file 

If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly.

[Anonymous]

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 · Accepted solution]

@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

[VijayP]

@Anonymous  use Field Parameters to achieve this