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

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.