Dynamic Group By Row Count

[j_gan2022]

I want these feature in my report

1) create a passing grade which is X% of the top scorer. eg. Top scorer = 80, if X% = 50%, passing grade = 40.

2) createa a slicer that can adjust X%.

3) a visual that can show how many passed or fail based on the slicer

Please advise how can I do it. I have created a measure for point 2) but i can't use the measure for group by to achieve 3).

Student ID	Score
1	66
2	77
3	43
4	45
5	70
6	80
7	55
8	50
9	76
10	20

[Thejeswar]

Hi @j_gan2022

You can use the what if parameters to achieve this

1. Create what if parameter, this will create a slicer and a measure as well

2. Create another measure as follows

checkcondition = if(SUM(exam[Score]) > mark_what_if[mark_what_if Value], 1, 0)

3. Use this new measure as visual filter to the visual where you want to dynamically filter the data based on selection

[j_gan2022]

Hi, I can't use 2) as slicer. Can you show me how to use as a slicer instead? Thanks

[Thejeswar]

Hi,

You can create a column with the below DAX. This column you can use in a slicer

checkconditioncolumn = if(exam[Score] > mark_what_if[mark_what_if Value], 1, 0)

[amitchandak · Accepted solution]

@j_gan2022 , when you create what if, you will get a what if measure, of you can get like

whatif measure = maxx(allselected(whatif) , whatif[value])

measure 

1. when score is a column
countrows(filter(table, table[Score] >= [whatif measure]))

1. when score is a measure
countX(filter(values(table[Student ID]), [Score] >= [whatif measure]), [Student ID])