Forum Discussion

b2wise's avatar
b2wise
Helper III
2 years ago
Solved

Pivot a Table Visual (DAX Measure Concept Help)

Hi all,   I find myself many times putting together a table visual in Power BI and then exporting it to Excel so I can pivot and find some more insights. Instead of exporting to excel I'd like to s...
Need Help
  • Jihwan_Kim's avatar
    Jihwan_Kim
    2 years ago

    Hi,

    I am not sure if I understood your question correctly, but I tried to create a sample pbix file like below.

    Please check the below picture and the attached pbix file if it suits your requirement.

     

     

     

     

    Sales measure: = 
SUM( Sales[Sales] )

     

    distinct product sold: = 
COUNTROWS(SUMMARIZE(Sales, 'Calendar'[Date]))

     

    expected result measure: = 
SUMX (
    FILTER (
        SUMMARIZE ( Sales, Category[Product Catetory] ),
        [distinct product sold:]
            = SELECTEDVALUE ( 'Product Sold distinct count CT'[Count] )
    ),
    [Sales measure:]
)

     

Jihwan_Kim's avatar
Jihwan_Kim
Super User
2 years ago

Hi,

I am not sure if I understood your question correctly, but I tried to create a sample pbix file like below.

Please check the below picture and the attached pbix file if it suits your requirement.

 

 

 

 

Sales measure: = 
SUM( Sales[Sales] )

 

distinct product sold: = 
COUNTROWS(SUMMARIZE(Sales, 'Calendar'[Date]))

 

expected result measure: = 
SUMX (
    FILTER (
        SUMMARIZE ( Sales, Category[Product Catetory] ),
        [distinct product sold:]
            = SELECTEDVALUE ( 'Product Sold distinct count CT'[Count] )
    ),
    [Sales measure:]
)