Need help in displaying Average value/level in the card

[abhishek_2593]

Hi All,  

I have a table which is calculating the disctinct counts under each levels as below, i want to display in a card the average of these levels' name.

i am finding it difficult to calculate as it is a string.

could somone please suggest an alternate way?

Thanks in advance 

Referees	Total referees
Developer	220
Level 0	5
Level 1	24
Level 2	16
Level 3	320
Level 4	400
Level 5	900
Level 6	1200
Level 7	2880
Total	5965

[Ashish_Mathur]

Hi,

Based on the table that you have shared, show the expected result.  Also, share the download link of your PBI file.

[Anonymous · Accepted solution]

Hi @abhishek_2593 ,
Depending on the information you have provided, you can follow these steps below:

1.Add an index column.

2.Add new measure.

Weighted Average Level = 
VAR _1 =
    CALCULATE ( SUM ( 'Table'[Index] ), FILTER ( 'Table', 'Table'[Index] >= 0 ) )
        / CALCULATE ( COUNTROWS ( 'Table' ), FILTER ( 'Table', 'Table'[Index] >= 0 ) )
RETURN
    "Level " & _1

Final output:

How to Get Your Question Answered Quickly - Microsoft Fabric Community

If it does not help, please provide more details with your desired out put and pbix file without privacy information.

Best Regards,

Ada Wang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.