Forum Discussion

Saxon10's avatar
Saxon10
Icon for Post Prodigy rankPost Prodigy
5 years ago
Solved

Frequency Count

  I have a two tables are data and report. In data table contain Date, Item and Vendor.   Report table contain item only. (Item stored as text format. Item column data type is mixed – Sometimes nu...
Need Help
Fowmy's avatar
Fowmy
Icon for Super User rankSuper User
5 years ago

Saxon10 

I created a measure, you can add the ITEM column from Report and the measure. Check the attached file. You can use the slicer to filter for any date period.

 

Freq = 
MAXX(
    TOPN( 
        1 , 
        ADDCOLUMNS(VALUES(DATA[Vendor]),"Count", CALCULATE(COUNT(DATA[Vendor]))),[Count]
    ),
    [Vendor]
)

 

 

Saxon10's avatar
Saxon10
Icon for Post Prodigy rankPost Prodigy
5 years ago

Thanks for your reply.

Is there any chance can I get the New calculate column instead of measure because based on the result column (Frequency).