Forum Discussion

parry2k's avatar
parry2k
Super User
8 years ago
Solved

count by measure

hi there,   I have  a calculated measure to calculate the share % of each category, based on category share there is ranking, if % > 20 then A if % > 10 then B else C   I added the measure for ra...
Need Help
  • Vvelarde's avatar
    Vvelarde
    8 years ago

    parry2k

     

    Try with this modification:

     

    RANK =
VAR Share = [% share]
RETURN
    IF ( Share > 0.10, "A", IF ( Share > 0.05, "B", "C" ) )

    Victor

  • parry2k's avatar
    parry2k
    8 years ago

    VvelardeThanks for getting back. Although I sorted it out but wanted to check how you experts will do. I will test your solution. Cheers!!

parry2k's avatar
parry2k
Super User
8 years ago

Hi Zubair_Muhammad

 

I was doing the same but here are few changes which I made and it is not working:

 

- No sum on amount in table to calculate %

- % is calculated based on allselected

- small change in rank formula to get 3 values

 

- made changes to "measure" to allselected instead of allselected(Table1[Category]) 

 

now if you select multiple values in slicer, you don't get correct result. Take a look, I made the changes in attached.

 

Thanks,

P

 

- 

    • Vvelarde's avatar
      Vvelarde
      Community Champion
      8 years ago

      parry2k

       

      Try with this modification:

       

      RANK =
VAR Share = [% share]
RETURN
    IF ( Share > 0.10, "A", IF ( Share > 0.05, "B", "C" ) )

      Victor

      • parry2k's avatar
        parry2k
        Super User
        8 years ago

        VvelardeThanks for getting back. Although I sorted it out but wanted to check how you experts will do. I will test your solution. Cheers!!