Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Measures by classification

Hi Experts,   I have a question that struggle me for a time, would anyone can help me to solve? I would like to create 4 measures (It's 2 types of measure in fact)   Please find the raw sample f...
Need Help
  • Ashish_Mathur's avatar
    Ashish_Mathur
    6 years ago

    Hi,

    You may download my PBI file from here.

    Hope this helps.

Anonymous's avatar
Anonymous
Not applicable
6 years ago

 

 

Please find my PBIX file

Download here 

 

Many thanks

Ashish_Mathur's avatar
Ashish_Mathur
Super User
6 years ago

Hi,

Those answers seem correct to me.  The 3 items that you see in Table2 : B-B-VFSM, B-B-VFSPM and B-S-PBS(S) have codes other than 1 and 2 (see the 3 screenshots below).  In the [A only] measure, we have excluded "Other".  There is no Other entry in the Code column in your dataset.  I guess you want to exlude all except codes 01 and 02.  If that indeed is the case, then the formula will have to be modified.

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Oh So sorry for my careless mistake :smileyfrustrated:

    Thanks so much