Forum Discussion
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...
Hi @Penn
It is ok?
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()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.
Hi @Penn
It is ok?
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()
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.
Thanks Maggie, works fine with the example, will integrate into my report.
