5)Perform all in built functions based on a condition for suitable Datatype

[Anonymous]

I am new to Power BI. I have a below sample table. But in real time I have multiple columns, When I perform some in built aggregate condition for any suitable column, it should do based on a condition i.e. Do only for "Individual". This should be applicable for any function(Sum, Average, Count,Maximum, Minimum, Standard Deviation, variance, median)

For E.g. If I do take time and Rate(for Time =5) columns. Now if I chose inbuild function for Rate(Average). It should calculate function based on Col1 value "Individual".  - 41.7333.

Col 1	Rate	Time (In Mins)	Col 4	Col 5
individual	44.5	5	37	NA
individual	40.6	5	37	NA
individual	40.1	5	37	NA
Mean	41.7	5	37	NA
Range	40	5	37	NA
RSD	5.8	5	37	NA
SD	2.4	5	37	NA
individual	55.7	10	37	NA
individual	52.4	10	37	NA
individual	52.2	10	37	NA
Mean	53.4	10	37	NA
Range	52	10	37	NA
RSD	3.7	10	37	NA
SD	2.0	10	37	NA
individual	61.9	15	37	NA
individual	58.9	15	37	NA
individual	58.5	15	37	NA
Mean	59.8	15	37	NA
Range	59	15	37	NA
RSD	3.1	15	37	NA
SD	1.9	15	37	NA
individual	69.7	30	37	NA
individual	67.3	30	37	NA
individual	67.2	30	37	NA
Mean	68.1	30	37	NA
Range	67	30	37	NA
RSD	2.1	30	37	NA
SD	1.4	30	37	NA
individual	73.1	45	37	NA
individual	72.9	45	37	NA
individual	71.5	45	37	NA
Mean	72.5	45	37	NA
Range	72	45	37	NA
RSD	1.2	45	37	NA
SD	0.9	45	37	NA
individual	76.8	60	37	NA
individual	74.6	60	37	NA
individual	74.3	60	37	NA
Mean	75.2	60	37	NA
Range	74	60	37	NA
RSD	1.8	60	37	NA
SD	1.4	60	37	NA

Thanks in Advance.

[amitchandak]

@Anonymous , Not very clear. Try like

calculate(average(Table[Rate]),table[Col1]="Individual")

calculate(Sum(Table[Rate]),table[Col1]="Individual")

calculate(Min(Table[Rate]),table[Col1]="Individual")

calculate(MAx(Table[Rate]),table[Col1]="Individual")

https://docs.microsoft.com/en-us/dax/statistical-functions-dax

[Anonymous]

@amitchandak, Thanks for this info. But if you could see the below screenshot, I want the in-built functions to be performed on a condition. This is because my chart is not going to be static, I am going to include personalise Visual where user can change data at run time, following which if he opts for any different column, the data should be calculate with a condition.

[v-lionel-msft]

Hi @Anonymous ,

Like this?

Custom column = Rate colum

Best regards,
Lionel Chen

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

[Anonymous · Accepted solution]

Thanks for your reply, I was able to sort it out by filtering the values. Thanks