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,

 

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,

      • Anonymous's avatar
        Anonymous
        Not applicable
        7 years ago

        Hello v-jiascu-msft,

         

        I just wanted to update for anybody keeping up with the thread that the problem lied within the relationships between my tables. I had to delete one relationship and add a new one to make the filtering work correctly.

         

        I appreciate your help!