Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Measure in chart

Hi all,   I created a measure which works fine in table. But if I add it to a chart, it shows different values.   My Data ID Type Field Customer Picking Date Best before 1 Banana A ...
Need Help
  • Anonymous's avatar
    Anonymous
    7 years ago
    PickFirst =
IF (
    ISFILTERED ( Table1[Customer] ),
    CALCULATE (
        IF (
            SELECTEDVALUE ( Table1[Picking Date] )
                = CALCULATE (
                    MIN ( Table1[Picking Date] ),
                    VALUES ( Table1[Type] ),
                    ALLSELECTED ( Table1 )
                ),
            1,
            0
        ),
        FILTER (
            Table1,
            IF (
                SELECTEDVALUE ( Table1[Picking Date] )
                    = CALCULATE (
                        MIN ( Table1[Picking Date] ),
                        VALUES ( Table1[Type] ),
                        ALLSELECTED ( Table1 )
                    ),
                1,
                0
            ) > 0
        )
    ),
    VALUES ( Table1[FirstPick] )
)

    Use this code.

    First Pick is column created previous provided pbix.

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Hi Anonymous 

 

thanks for your fast reply.

 

But I need a measure. With a calculated column I can't filter on e.g. customer and the picking date will be calculatet. It is still the same. So I need this measure.

 

Best regards

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Anonymous ,

 

I am still not clear about your requirement.

You can use the measure created by you and change X-axis type to Categorical.

Solution

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    Hi Anonymous 

     

    I like to show the first picking dates in a column chart. Depending on the filter the bar chart should change.

     

    If you set a filter in your file it also doesn't show me the correct results.

     

    Why I only have data for January? The Measure in March is also 1 ... Do you know what I mean?

    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago
      PickFirst =
IF (
    ISFILTERED ( Table1[Customer] ),
    CALCULATE (
        IF (
            SELECTEDVALUE ( Table1[Picking Date] )
                = CALCULATE (
                    MIN ( Table1[Picking Date] ),
                    VALUES ( Table1[Type] ),
                    ALLSELECTED ( Table1 )
                ),
            1,
            0
        ),
        FILTER (
            Table1,
            IF (
                SELECTEDVALUE ( Table1[Picking Date] )
                    = CALCULATE (
                        MIN ( Table1[Picking Date] ),
                        VALUES ( Table1[Type] ),
                        ALLSELECTED ( Table1 )
                    ),
                1,
                0
            ) > 0
        )
    ),
    VALUES ( Table1[FirstPick] )
)

      Use this code.

      First Pick is column created previous provided pbix.

       

      If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.