Need Help on creating Measure

[Amardeep100115]

Hi 
I would like to have an measure which will count the services according to column value. with help grouping the the measure by the Service type

also i wish to have change value according to selection in slicer. and column header in below table in BI file

Every column has below suffix and they should use as a slicer. i have given them on second page (Sheet) in excel file 

Sample data

PBIX file 

[mahoneypat]

Thank you for providing the pbix file, but please also provide an example of what the correct output would be for one or two calculations (input numbers and correct result for a given set of slicers, row, column.

Regards,

Pat

[Amardeep100115]

Hi @mahoneypat 

Please refer below youTube Video and i would like to have similer output when select the slicer

Measures are already created but on seletction grouped columns are have to be display into table



https://www.youtube.com/watch?v=a4zYT-N-zsU&t=570s&ab_channel=SQLBI