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,

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!

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

        Hi Anonymous,

         

        I don't have access to the file with my account. Could you check the sharing status please? Maybe you should share it outside your organization. 

         

        Best Regards,