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,

 

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

Hi v-jiascu-msft,

 

I can't upload a file from my organization to a place outside of the organization. Is there any way to send this .pbix file to you another way?