Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Counting a measure return

Hello,   I'm linking to a previous post of mine to help give more context if needed.   https://community.powerbi.com/t5/Desktop/Measures-affected-by-slicer-choice/m-p/595019#M282535   I have a ...
Need Help
  • v-jiascu-msft's avatar
    v-jiascu-msft
    7 years ago

    Hi Anonymous,

     

    Please try a solution like below. 

    1. Create a new table [Sellers].

    Sellers = VALUES('Table'[SELLER])

    2. Create a measure.

    Measure =
SUMX (
    ADDCOLUMNS (
        SUMMARIZE ( 'Table', 'Table'[ITEM ID], 'Table'[SELLER], 'Table'[PRICE] ),
        "ifMinPrice", IF (
            [PRICE]
                = CALCULATE (
                    MIN ( 'Table'[PRICE] ),
                    ALL ( 'Table'[SELLER], 'Table'[PRICE] ),
                    ALLSELECTED ( 'Sellers'[SELLER] )
                ),
            1,
            0
        )
    ),
    [ifMinPrice]
)

    Counting-a-measure-return

     

    Best Regards,

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Hello v-jiascu-msft

 

Thanks for the response.

 

I applied this to my data, and it works when I do not filter any sellers out in my slicer.

 

When something is selected in my slicer, it only filters to show the value from "all selected", not what the results would be when including all the selected sellers to find the minimum price seller.

 

The original table where the lowest price seller is showing the correct data, but not the visual I created from the most recent measure.

 

Let me know if that's not clear. Thanks!

v-jiascu-msft's avatar
v-jiascu-msft
Microsoft Employee
7 years ago

Hi Anonymous,

 

Do you have an independent table [Sellers] that the slicer is from? If you have done all the steps in my last post, please share a more accurate sample. Please mask the sensitive parts first.

 

Best Regards,

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    Hello v-jiascu-msft,

     

    When I use the filter from the separate Sellers table, nothing will filter on the page. I would have a hard time sending the data and covering anything sensitive. I would basically have to cover everything. I created a report with data that is very similar to my own, but not actual data. I have put in the measures and visuals already exactly how it is set up in my actual report and the data types are the same as what I am using.

     

    I can't find a way to share this through a message, is there any way to send a .pbix?

     

    Thanks! 

    • v-jiascu-msft's avatar
      v-jiascu-msft
      Microsoft Employee
      7 years ago

      Hi Anonymous,

       

      You can upload it to the cloud drive like OneDrive then share the download link here. Please mask the sensitive parts.

       

      Best Regards,

      • Anonymous's avatar
        Anonymous
        Not applicable
        7 years ago

        Hello v-jiascu-msft,

         

        Nothing is sensitive because this is all fabricated.  Below is the download link for the report:

         

        link

         

        Thank you!