Forum Discussion

Lucky71's avatar
Lucky71
Frequent Visitor
3 years ago

DAX Create Dynamic Virtual Table - Based on Slicer

Hi   I want to be able to create Virtual Table which is dependant on a slicer. If Region slicer is... being used:           Return the entire table NOT being used:   Return a Summarized version ...
Need Help
foodd's avatar
foodd
Community Champion
3 years ago

Please provide your work-in-progress Power BI Desktop file (with sensitive information removed) that covers your issue or question completely in a usable format (not as a screenshot).


https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-...


Please show the expected outcome based on the sample data you provided.

https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447...

 

This allows members of the Forum to assess the state of the model, report layer, relationships, and any DAX applied.

  • Lucky71's avatar
    Lucky71
    Frequent Visitor
    3 years ago

    I've uploaded the PowerBI file here:

    UploadFiles

    Thank you