Forum Discussion

Penn's avatar
Penn
Resolver I
6 years ago
Solved

Help convert a table into a chart

Hi all,   I have simplied my question and upload an example file here:  https://drive.google.com/file/d/1sLSgz5iNBRoj07_yMIkgzpuXBxwfPVCk/view?usp=sharing   The raw data looks like this. Case T...
Need Help
  • v-juanli-msft's avatar
    v-juanli-msft
    6 years ago

    Hi @Penn

    It is ok?

    Capture1.JPG

    Creating Measures

    fill status = CALCULATE(FIRSTNONBLANK('Case'[EOM Status],1),FILTER(ALLSELECTED('Case'),'Case'[EOM Date]<=MAX('Case'[EOM Date])))

Disqulifed = CALCULATE(DISTINCTCOUNT('Case'[Case ID]),FILTER(ALLSELECTED('Case'[Case ID]),'Case'[fill status]="Disqualified"))

converted = CALCULATE(DISTINCTCOUNT('Case'[Case ID]),FILTER(ALLSELECTED('Case'[Case ID]),'Case'[fill status]="Converted"))

    the 'date2' is a table created by me and has a relationship with the main table

    date2 = CALENDARAUTO()

    Capture2.JPG

    Best regards
    Maggie
    Community Support Team _ Maggie Li
    If this post helps, please consider Accepting it as the solution to help other members find it more quickly.

Penn's avatar
Penn
Resolver I
6 years ago

all measures can be found in the attached file