Forum Discussion

Rich_F's avatar
Rich_F
New Member
3 years ago

Using field parameter in a count() measure

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
 

2 Replies

  • nhniniras's avatar
    nhniniras
    Frequent Visitor
    3 years ago

    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