Count of records based on displayed measure values

[Teena_Pa4]

Hi,

I have a table with 2 measures that I need to divide:

Test = Measure A/Measure B

Measure B calculates on specific values (using allexcept) and on a per row level. My table displays the data based on a higher dimension and I need to count how many records are there if Test is less than 0.5 (Test < 0.5). What it's doing is counting the result of Test based on per row and not based on the what is displayed on the table. Example:

Measure A     Measure B (average of records based defined by AllExcept)    Test

1000              5000                                                                                            0.2

2000              5000                                                                                            0.4

4500              5000                                                                                            0.9

I need to get count of 2 rather than counting for the result of Measure A over the different combinations of Measure B due to AllExcept values. I am using Countx and Filter.

Is ther a way to do this? Thank you.

[Ashish_Mathur]

Hi,

Share the link from where i can download your PBI file.

[v-lili6-msft]

hi, @Teena_Pa4

Could you please tell me if your problem has been solved? If it is, could you please mark the helpful replies as Answered?

Best Regards,

Lin

[v-lili6-msft · Accepted solution]

hi, @Teena_Pa4

It sounds like a measure total problem, you could refer to this post:

https://community.powerbi.com/t5/Quick-Measures-Gallery/Measure-Totals-The-Final-Word/m-p/547907

By the way, you could add a new measure like this 

 measure = IF( [Test] < 0.5, 1, 0)

Then use SUMX Function to count the result what you want.

Best Regards,

Lin