Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Adding consolidation to existing function

I am in desperate need of a solution that I have been trying to find for so long. I have a report evaluating how well a vendor does in getting our product to us on time and with a minimum condition o...
Need Help
  • v-kelly-msft's avatar
    v-kelly-msft
    5 years ago

    Hi Anonymous ,

     

    Create a measure as below:

    Measure = CALCULATE(COUNT('Table'[Test PO Fulfill]),FILTER(ALL('Table'),'Table'[Test PO Fulfill]=MAX('Table'[Test PO Fulfill])))

    And you will see:

    For the related .pbix file,pls see attached.

     

    Best Regards,
    Kelly
    Did I answer your question? Mark my post as a solution!
Anonymous's avatar
Anonymous
Not applicable
5 years ago

I am not sure if I understand your question correctly ... you would like a donut chart which measures the percentage represented by each of the status (which is a metric calculated by the formula you provided)?

Technically it's not possible to add measures to the legend of the visual, so ..... one way to look at the problem is that you can create a table containing the status you want, and then create another measure that reflects the count of the status. The dimension table shall look something like this:

The measure looks like this (I didn't test the expression ... just to give you an idea of the DAX expression):

Count = VAR _tbl = SUMMARIZE(OnTimeDelivery,[PONumber],[POLineNumber,[ItemNumber],"PO Status",[Test PO Fulfill]])
        VAR _legend = FIRSTNONBLANK(Table,[Status])
        RETURN COUNTROWS(FILTER(_tbl,[PO Status]=_legend))

I hope you get my point.