Countif in pivot

[Sriku]

Hi Team,

After applying filter in the data I need to count how many are H/M/L  (L <5,M<8,H>8) and based on the count need to plot a pie.

Please help.

[v-lili6-msft · Accepted solution]

hi  @Sriku 

If [H/M/L] is a calculate column or calculate measure?

If it is a calculate column, you could just drag [H/M/L] column into legend of a pie chart and then drag [Count of H/M/L]in Value and set aggregate type is Count.

If it is a calculate measure, you need a separate table that contains 'Low' 'Medium' 'High',

then create a measure like below logic

Measure 3 = var _table=FILTER(CROSSJOIN(ADDCOLUMNS('Fact',"_type",[Measure]),'Type'),[_type]=[Type]) return
COUNTROWS(_table)

here is a same post i have solved, you could refer to it

https://community.powerbi.com/t5/Desktop/Use-measure-as-chart-legend/m-p/1237315#M547738

Regards,

Lin

[amitchandak]

@Sriku , You need to try segmentation/ binning

https://www.daxpatterns.com/dynamic-segmentation/
https://radacad.com/grouping-and-binning-step-towards-better-data-visualization

https://www.daxpatterns.com/static-segmentation/
https://www.poweredsolutions.co/2020/01/11/dax-vs-power-query-static-segmentation-in-power-bi-dax-po...