Need Help on creating Measure

Question

Hi&nbsp;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 typealso i wish to have change value according to selection in slicer. and column header in below table in BI fileEvery column has below suffix and they should use as a slicer. i have given them on second page (Sheet) in excel file&nbsp;&nbsp;Sample data&nbsp;PBIX file&nbsp;&nbsp;&nbsp;&nbsp;

mahoneypat · Answer

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.
&nbsp;
Regards,
Pat
&nbsp;

anonymous · Answer

Hi&nbsp;mahoneypat&nbsp;Please refer below youTube Video and i would like to have similer output when select the slicerMeasures are already created but on seletction grouped columns are have to be display into tablehttps://www.youtube.com/watch?v=a4zYT-N-zsU&amp;t=570s&amp;ab_channel=SQLBI&nbsp;&nbsp;&nbsp;&nbsp;

Forum Discussion

Need Help on creating Measure

2 Replies

Related content

Need help creating a measure

Help to create DAX Measure

Create count measure

Creating new measure, only showing other measures

Create Measure to Return Highest Value