Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

dax measure


I have a measure that I am trying to visualize in a certain row in a table.

Here is the measure:

01 Net Return on Sales = DIVIDE([D075 Net Profit],[D005 Total Sales],0)


This measure returns a score for the result of Net Return on Sales:

Your Score =

CALCULATE(
MAX(test[Column1]),
FILTER(
ALL(test),
test[Column2] <= '60 HPM'[01 Net Return on Sales] &&
test[Column3] >= '60 HPM'[01 Net Return on Sales]
)
)
 
Here is the lookup table:



On this visual I want the measure to show up on the correct row:

When I bring this measure

Your Rate M =

CALCULATE(

[01 Net Return on Sales],

FILTER(
ALLEXCEPT(bq_master_common_location,bq_master_common_location[Master_Common_Location]),

[Your Score] = SELECTEDVALUE(test[Column1])

))
on grid, it filters the rows.  I want to show all rows, and have the measure rate show on the correct row

 

Please advise,

Need Help
  • Anonymous's avatar
    Anonymous
    4 years ago

    Hi Anonymous ,

     

    Please try to right-click [Column1] (In my example, is [Attribute]) , check "Shown items with no data"

    Or if you are still confused about it, please provide me with more details about your table and your problem or share me with your pbix file after removing sensitive data.

     

     

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

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Hi Anonymous ,

     

    Please try to right-click [Column1] (In my example, is [Attribute]) , check "Shown items with no data"

    Or if you are still confused about it, please provide me with more details about your table and your problem or share me with your pbix file after removing sensitive data.

     

     

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

    • Anonymous's avatar
      Anonymous
      Not applicable
      4 years ago

       

      Excellent!  This worked.  Very much appreciated!


      Dave