Forum Discussion

nirvana_moksh's avatar
nirvana_moksh
Impactful Individual
7 years ago
Solved

Creating IF Statement Over Category

Hello All,   I am running into an issue trying to write a measure/calc. column which is basically an IF statement that classifies items:   Classification = IF([Sum] < 5000000 , "<$5M", IF([Sum] ...
Need Help
Show and Tell
  • Ashish_Mathur's avatar
    Ashish_Mathur
    7 years ago

    Hi,

    You may download my PBI file from here.

    Hope this helps.

Ashish_Mathur's avatar
Ashish_Mathur
Super User
7 years ago

Hi,

Share some data and show the exact expected result in a Table format.  Once the Table format is ready, we can switch to a Pie visual.

nirvana_moksh's avatar
nirvana_moksh
Impactful Individual
7 years ago

Ashish_Mathur - Here is the link to the file which contains the sample data with few details listing out the issues which you can download. This has been so annoying, I feel I am missing something very basic here. Thanks a lot in advance Ashish!