Need find over 10% change item and count item

[WendyWang303]

Report need show over 10% item for example, total item is 46, only 8 item over 10%, so need to show over 10% item percentage: 

8/46 = 17.4%, but in my dax, I cannot get sum of over 10% item, I need dax show sum is 8 not 1, 

when I create measure like under, all not works 

[v-veshwara-msft]

Hi @WendyWang303 ,
Thanks for reaching out to Microsoft Fabric Community.

Just checking in to see if the solutions shared have worked for you.
Otherwise, feel free to reach out for further assistance.

Thank you.

Also thanks to @Ashish_Mathur , @Shahid12523  and @danextian for sharing your ideas.

[danextian]

Hi @WendyWang303 

The formula depends on the column the change % is being evaluated. You really would not want to evaluate that for the whole table that as that could become an exprensive calculation depending on its size. Try @Ashish_Mathur's solution.

[Shahid12523]

Use measures instead of a calculated column:

Over10Pct Items =
CALCULATE (
COUNTROWS ( YourTable ),
FILTER ( YourTable, [Change %] >= 0.1 )
)

Over10Pct % =
DIVIDE ( [Over10Pct Items], COUNTROWS ( YourTable ), 0 )

This will give you:

Over10Pct Items = 8

Over10Pct % = 17.4%

Put them in a card visual for totals.

[Ashish_Mathur · Accepted solution]

Hi,

Assuming the left most column (currently invisible in the image that you have shared) in the visual is Category from the Monthly house cost table, try these measures

Count = countrows('Monthly house cost')

Count with condition = countrows(filter(values('Monthly house cost'[Category]),[Change %]>0.1))

Ratio = divide([Count],[Count with conditions])

Hope this helps.