Forum Discussion

PeterChen's avatar
PeterChen
Icon for Helper I rankHelper I
2 years ago
Solved

How to fetch number from visual matrix

I have a data like this: ## TABLE1 Group Type Num_Col_1  Num_Col_2 A X 10 50 B X 20 1000 C X 30 900   I create a TABLE2: TABLE2 = DISTINCT(TABLE1[Group])   I created...
General Comment
Need Help
  • v-zhangti's avatar
    v-zhangti
    2 years ago

    Hi, PeterChen 

     

    You can try the following methods. Measure 1 No change.

    Measure2 = RANKX(ALL(TABLE2[Group]), TABLE2[Measure1],,DESC)
    Measure3 = DIVIDE([Measure2] - 1, COUNTROWS(ALL(TABLE2)) - 1)

     TABLE2[Group] as a slicer.

    Is this the result you expect?

     

    Best Regards,

    Community Support Team _Charlotte

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

     

Ashish_Mathur's avatar
Ashish_Mathur
Icon for Super User rankSuper User
2 years ago

Hi,

I'd like to try.  Share the download link of the PBI file.