Power BI Exchange

Please login or click SIGN UP FOR FREE to create your PowerBIUG account to join this user group.
Expand all | Collapse all

Count of a Measure in a Matrix

  • 1.  Count of a Measure in a Matrix

    Posted 11 days ago
    I have a Measure "Fast Count" in a matrix below that will change based on Slicers (not shown).  I want whatever is the current count of Fast Count placed in a disconnected table as shown on the right below. I have struggled with this for far too long and would appreciate any suggestions.  Thanks in advance.

    Bill Harper

    Count of Measure


    ------------------------------
    William Harper
    Principal Engineer
    Dublin OH
    ------------------------------
    Academy - Online Interactive Learning from Experts


  • 2.  RE: Count of a Measure in a Matrix

    Bronze Contributor
    Posted 10 days ago

    Hi William, could you share more information?

    1) what is dax calculation for "Fast Count"
    2) the list of slicers and which data is in slicers
    3) data model (relationships) image

    If i understand well, image on the right is disconnected table and you would like to use count of that column (count of A, count of B, count of X42...) to populate some data on crosstab (image on left)?



    ------------------------------
    Nemanja Andic
    BI developer
    Belgrade
    ------------------------------

    Academy - Online Interactive Learning from Experts


  • 3.  RE: Count of a Measure in a Matrix

    Top Contributor
    Posted 10 days ago
    Hi @William Harper,

    Please can you share more information as to how your data is modeled, the business logic, how is the Fast count being calculated for the joint and share a sample file with the community.​

    Thank you,

    ------------------------------
    Vishesh Jain
    Owner
    VR Construction
    ------------------------------

    Academy - Online Interactive Learning from Experts


  • 4.  RE: Count of a Measure in a Matrix

    Posted 10 days ago
      |   view attached
    Thanks to both of you!  Really appreciate it. Below is an updated image but I have also attached the PBI file.   I hope I am uploading things properly since this user group is pretty new to me. Thanks, Bill
    updated image with Slicer and comments


    ------------------------------
    William Harper
    Principal Engineer
    Dublin OH
    ------------------------------

    Attachment(s)

    Academy - Online Interactive Learning from Experts