Count a frequency measure

Question

I have a measure which counts the number of transactions per id within a timeframe (from slicer):&nbsp;mFrequency = IF(DISTINCTCOUNT(RPT_FACTORDER[TRANSACTION_NUMBER]) = BLANK(), 0,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; IF(DISTINCTCOUNT(RPT_FACTORDER[TRANSACTION_NUMBER]) = 1, 1,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; IF(DISTINCTCOUNT(RPT_FACTORDER[TRANSACTION_NUMBER]) = 2, 2,&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; IF(DISTINCTCOUNT(RPT_FACTORDER[TRANSACTION_NUMBER]) = 3, 3, 4))))&nbsp;Which gets me output like this:&nbsp;Id&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; mFrequency111&nbsp;&nbsp;&nbsp; 1222&nbsp;&nbsp;&nbsp; 1333&nbsp;&nbsp;&nbsp; 3444&nbsp;&nbsp;&nbsp; 2555 &nbsp;&nbsp; 1&nbsp;Now I need to count up the measure (mFrequency) to get results which look like this, and change based on the slicer timeframe:&nbsp;mFrequency Count1 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; 32&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 13&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 14&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 0&nbsp;I'm new to Power BI.&nbsp; Help is appreciated.&nbsp; Thanks.

sturlaws · Accepted Answer

Hi,&nbsp;since you need frequency on the axis, you need to add a stand-alone table with the neccessary values. And based on those values, count the number of IDs with corresponding frequency.This measure would look like thisMeasure =
VAR _count =
    COUNTROWS (
        FILTER (
            ADDCOLUMNS (
                VALUES ( 'Table'[id] );
                "@freq";
                VAR _trans =
                    CALCULATE ( SUM ( 'Table'[transactions] ) )
                RETURN
                    IF ( _trans &gt; 3; 4; _trans )
            );
            [@freq] = SELECTEDVALUE ( Frequency[F] )
        )
    )
RETURN
    IF ( ISBLANK ( _count ); 0; _count )Since you have not provided any data or sample report, I have created a mockup dataset and created a demo report based on that dataset: pbixcheers,S

Forum Discussion

Count a frequency measure

2 Replies

Related content

Count Measure

Enhancement Request – Add Visit Frequency Count to Employee Location Measure

Frequency Count

DAX - Frequency Count.

Counting nulls