Using field parameter in a count() measure

[Rich_F]

Hi, 

I was wondering if anyone has a way of using a selectedvalue from a field parmeter within a count measure. So, using a measure/varible rather than a  column reference as an argument in the count(). Like the below:

Counts_for measure =

var parameter_selected= SELECTEDVALUE(Parameter[Parameter Fields])

var numerator  = CALCULATE(COUNT(parameter_selected))
return

numerator  

I have a long list of fields that thought i could put into a field parameter, and then create some measure ( percentages) that would be dynamic when the fields parameters are filtered. 

Any pointers appreciated, 

Thanks,

Rich

[nhniniras]

Hi, 
I have the same problem and have solved it with a Swithc function (but I guess there should be a more simple solution)

SWITCH (
SELECTEDVALUE ( Parameter[Parameter Fields] ),
"'DimOrganisation'[BU]", DISTINCTCOUNT(DimOrganisation[BU]),
"'DimOrganisation'[Company]", DISTINCTCOUNT(DimOrganisation[Company]),
..........

It would be really nice if the Parameter fields could be used "directly" in a measure.
Just to be currious, have you found a better way to do it?

Regards Niels

[daXtreme]

Not getting replies? Well, it's time to read this: How to Get Your Question Answered Quickly - Microsoft Power BI Community