Forum Discussion

rpiboy_1's avatar
rpiboy_1
Helper V
2 years ago
Solved

Numeric Range (Parameter) returns multiple values in Matrix

Hi all,   I'm using a Numeric Range as a multiplication factor in my report. In a table the final measure calculates properly, where the factor value is properly applied to the measure I want to mu...
Need Help
  • rpiboy_1's avatar
    rpiboy_1
    2 years ago

    I win the dunce award... never sync'ed the parameter selection slicer from the first page of the report to the page that has the matrix visual... that is 100% on me... 😞 While attempting to investigate further, came accross Substack thread that caused me to double-check the slicer state/status....

EylesIT's avatar
EylesIT
Resolver II
2 years ago

rpiboy_1, I would suggest creating a measure with this DAX expression:

TestMeasure = COUNTROWS('Universal Grossing Factor')

 and see what numbers it returns for each cell of the matrix. This can help work out what is going on.

 

  • rpiboy_1's avatar
    rpiboy_1
    Helper V
    2 years ago

    The test measure was 'instructive' in that it comes back as 101 rows, which happens to be the total number increments available in the Numeric Range Parameter. So I guess my question becomes, how do I get to the 'right' context when using a Numerical Parameter with another Measure.

     

    When I add the test measure to the table, it also jumps to showing all the rows from the dimension table I'm using, so that is clearly the 'underlying' issue. I'm just not sure how to deal with it... 😞